Hi all,

I've been searching the archive and haven't found any pointers yet. If you will please shed some light.

I am sending information from our work application to accounting. The work data is VFP 6 sp5 free tables. The accounting app is Access 2002 MDB. I am connecting OK using SQLEXEC ODBC and inserting single records as well as querying Access and writing various foreign keys back to VFP. I need to send multiple related records to access (work order details kind of stuff).

Is SQLEXEC the best way to do this or should I be looking at ADO and OleDB?

I am only appending 2 to 10 records at a time so performance is not that big a deal.

TIA