OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register] 
 [Profile]   [Log in to check your private messages]   [Log in] 

Error when opening a V. FoxPro DB [SOLVED]

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
GEUTEN
Newbie
Newbie


Joined: 26 Aug 2009
Posts: 1
Location: Belgium
PostPosted: Wed Aug 26, 2009 6:03 am    Post subject: Error when opening a V. FoxPro DB [SOLVED] Reply with quote
BASE imports very well tables from FoxPro. But I have a problem when opening a table with a memo field (-.FTP). Only 2 records of the memo are linked to many records of the main table (each time it's an error). And the fields after the Memo field are mismatched.

I open the DBF file with an hexa editor : everything seems right. It seems everything is fine with the FTP file, too (my references are http://www.clicketyclick.dk/databases/xbase/format/).

I will re-learn the structure of FTP and build an ad hoc application.

Someone had the same problem ?

Thank you !
Geuten

Last edited by GEUTEN on Thu Aug 27, 2009 4:18 am; edited 1 time in total
Back to top
View user's profile Send private message
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2474
Location: 3rd Rock From The Sun
PostPosted: Wed Aug 26, 2009 7:46 am    Post subject: Reply with quote
Geuten:

Welcome to OpenOffice Base.

You said:
Geuten wrote:
BASE imports very well tables from FoxPro. But I have a problem when opening a table with a memo field (-.FTP).

Please look at the link below, and, the comments by Sliderule ( yes that is yours truly Laughing ). If you are using Windows as your operating system, you might want to recreate a NEW OpenOffice database file, and, rather than using the 'default' Open Office connector to your FoxPro files, use the Windows ODBC connection.

http://www.oooforum.org/forum/viewtopic.phtml?t=80523

I hope this helps, please be sure to let me / us know.

Sliderule

Thanks to add [Solved] in your first post title ( edit button ) if your issue has been fixed / resolved.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group