Hi,
I'm writing some code to use ADO to pull some data from access. Everything works fine but I want the data to be placed in an existing table and using CopyFromRecordset seems to wipe the table. I can use an ODBC query, change the command and refresh but I'm trying to learn more about ADO at the moment.
Is there a way to use INSERT INTO on an excel table using the SQL command in ADO?
Thanks
Nick
I'm writing some code to use ADO to pull some data from access. Everything works fine but I want the data to be placed in an existing table and using CopyFromRecordset seems to wipe the table. I can use an ODBC query, change the command and refresh but I'm trying to learn more about ADO at the moment.
Is there a way to use INSERT INTO on an excel table using the SQL command in ADO?
Thanks
Nick