What is the best way to pull data from a foxpro table and insert into an access
table using VB6. Currently I use ADO to pull the data from the Foxpro table,
write a delimited file then import that file to the access table. I have
tried multiple ADO connections in a single proceedure (one Foxpro one Access)
then tried an INSERT INTO SQL query from the Foxpro recordset to the Access
recordset, but it didn't work.