How to make ODBC Conn and transfer data... How to make ODBC Conn and transfer data... edrest (Programmer) (OP) 1 Sep 00 22:23 I need to PROGRAMATICALY make an ODBC connection from VFP to an Access table and then transfer the data in the VFP table to the Access table. Any help would be apprecaited. Tom Gahaganedrest@alltel.netREST If you get a chance to sit out or dance... I hope you dance. L Wommack RE: How to make ODBC Conn and transfer data... TomasDill (IS/IT--Management) 2 Sep 00 10:44 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=MyDatabaseDatabase 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.