Mike

I see you have a couple of suggestions. You could also check out MDB2DBC - Access to VFP Data Migrator in the download section.

Nick Mason
>I have plowed through a lot of documentation and played around with this and can't get what I want.
>
>I have a MS Access File (.mdb) on the same machine as my VFP application.
>
>I would like to read the MS Access File and use the data from it.
>
>I have gone through The Control Panel and ODBC and created a connection so I can view the .mdb file, but I haven't figured out how to bring the data into .dbf format so I can actually use it.
>
>This has lead me to chapters on SQL, COM, DCOM, ADO and RDO. As I read this stuff it appears to be trying to extract remote data that is sometimes in .dbf format already, so I am not sure which approach I should be using.
>
>Like I would just love it if the was an APPEND FROM command that I could use as for .XLS files.
>
>Before I go far down this trail, I would just like to find out which approach is best for extracting data from a .mdb file when it is on the same machine as the .dbf file. I will then focus my reading in that direction.
>
>Thanks.
>
>Mike Smith