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
Opportunity is missed by most people beacuse it is dressed in overalls, and looks like work --- Thomas Edison