Information générale
Titre:
Reading MS Acces Files from VFP
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement