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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only