Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to make ODBC Conn and transfer data...
- Thread starter edrest
- Start date
I'm not sure, but you may try to use SQL low-level functions. They all work using ODBC. Use following string for SQLStringConnect VFP function:
Server=MYSERVER;Driver=MicrosoftAccess Driver;UID=myneme;Passowrd=mypassword;Database=MyDatabase
Database may be with path. Above may require additional parameters, that are special for Access. I'm also not sure about MS Access ODBC driver name.
Than, SQLConnect(). Than, SQLExecute to run SQL Update command for Access table and transfer data.
Server=MYSERVER;Driver=MicrosoftAccess Driver;UID=myneme;Passowrd=mypassword;Database=MyDatabase
Database may be with path. Above may require additional parameters, that are special for Access. I'm also not sure about MS Access ODBC driver name.
Than, SQLConnect(). Than, SQLExecute to run SQL Update command for Access table and transfer data.
- Status
