I have a VFP program and am trying to rewrite it in MS ACCESS 2000.
The original DBF files are pretty simple, just TEXT fields and one MEMO
field..
The original VFP program is not too complicated, so I will be able to
manipulate the data easily in ACCESS.
..
I planned to use MS EXCEL to open the VFP dbf files and save them as XLS
files.
Then I would build the ACCESS program using these XLS files.

BIG problem with the MEMO field.

I tried "COPY MEMO" to save the memo data to a text file and later APPENDING
the text file to a seperate VFP dbf file .
I coded it up and it works fine as long as the MEMO field is less than 255
characters.

When I try to retrieve data from the seperate VFP dbf file I lose
everything after the first 255 characters, because that's the maximum size
of a VFP Text field. The MEMO fields never exceed 500 characters.

The bottom line is.... Does anyone know how to export or port the MEMO
fields into an XLS file or anything else readable by ACCESS.

Many thanks
Dick B

"RICHARD BROMBERG" <dickbrom (AT) worldnet (DOT) att.net> wrote

One way is to use ODBC connection VFP program -> Access database.
Write a simple VFP program reading DBF data and updating Access
database using SQL commands (insert ...)

Another way is to save MEMO fields into separate text files and import
text files (manually) into Access database. A little annoying.

Many Thanks for putting me on the right track .

I went to ODBC Data Source Administrator (Windows XP Professional) and
managed to add an Access Driver that specifically connects to a Visual
Foxpro Table.

With this driver Access imported/created the VFP table including
everything, including the MEMO fields.





"Jan Bucek" <bucek (AT) my-deja (DOT) com> wrote