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