Importing Visual FoxPro memo fields to Access

[BobMorris]

Anyone know how to import a FoxPro table with memo fields into an Access table with memo fields? A direct import doesn't seem to work, as Access doesn't recognize the FoxPro memo fields.

Do I need to write a macro?

Bob Morris

http://www.bomoco.com

 

[MIKElaw]

Visual Foxpro is a mod of the good old Ashton Tate dBase file. Legendsoft (

http://www.ledgendsoft.com)

have a dbf viewer which will read Fox files and export them as csv's It will also allow you to edit both the data, inc. memos, and the structure. Version 4.0.1 is available on the website as a 30 day unrestricted, I think, trial. Once in a csv import should not be too difficult and, if you are going to repeat the exercise it can be done in VBA

Hope this helps


Mike

 

[danvlas]

The memo fields in a Foxpro file are kept in another place (a cdx file if I remember well).

If you have both files, the import should go OK.

What Access version do you use?




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html