I already have a VBA macro developed that develops a SQL statement based on variable criteria and queries an Oracle database and returns an ADO recordset. I then paste the data into an open Execl workbook using the CopyFromRecordset command. This works great. However, idealy I would like to export the recordset to a CLOSED workbook that resides on a network server. Is there a way to open two connections (one to the Oracle server and another to the closed Excel workbook) and simply transfer the recordset from one to the other. That would make life wonderful.
Another thing that I would like to be able to do is transfer the same recordset to a new Access table.
Oh, by the way. Criteria for the query changes. They will return different fields, depending on the need.
Thanks for any help.
Another thing that I would like to be able to do is transfer the same recordset to a new Access table.
Oh, by the way. Criteria for the query changes. They will return different fields, depending on the need.
Thanks for any help.
