VFP program to open an MS Access table and add rows

[FoxNovice]

We are using VFP 6.0 and MS Access 2002. I would like to know if it is possible to set up a VFP program that will open a specific table within an MS Access database, add a row, and then populate that row with specific information from either fields from a .dbf or VFP memory variables.

If this can be done, could someone point me in the right direction, possibly with some applicable code? Again, I would like to be able to do this from within VFP.

Thanks!

 

[TamarGranor]

You can do this via ODBC. Look in VFP Help for the SQLConnect(), SQLExec() and SQLDisconnect() commands. Also, check out the Help topic "Using SQL Pass-Through Technology" and the related topics.

Tamar