Robert Smith gave a great tip on "Export to any type of database"... The tip was directed for DAO. Does this information work as well for ADO? I would like to export a recordset from one database such as Oracle or SQL Server and import or append it to an Access DB using ADO. After the data is processed, the path needs to be reversed. Export from Access DB using ADO and appending to Oracle or SQL server.
Thank you in advance
KW