General information
Category:
Coding, syntax & commands
>Is there a reasonable way to copy data from a VFP table to an Access MDB?
I use SQL Passthrough...
first you connect to the Access database this way
lcConnect = "DBQ=" + m.AccessDB + ";" + ;
"DEFAULTDIR=" + m.AccessDir + ";" + ;
"Driver={Microsoft Access Driver (*.mdb)};DriverId=281;" + ;
"FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;"
m.lnConnect = SQLSTRINGCONNECT(lcConnect)
Where m.AccessDB is the full path of the Access database.
m.AccessDir is the directory of the Access database.
m.lnConnect hold the connection handle for the access database..
When m.lnConnect > 0 you have a valid connection to the Access database.
then issue a series of commands to add records to the relavent tables
via
m.result=SQLEXEC(lnConnect,lcQuery)
Where m.lcQuery is the Access MDB command for adding a new record.
The cool thing is that once you've established a connection to the Access MDB you are passing Access SQL commands DIRECTLY via the SQLEXEC command.
Thus, you are using Access/JET SQL language to add records.
then issue
= SQLDISCONNECT(lnConnect) to release the connection with the AccessMDB
good luck
Previous
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