Temporary table and recordset connection problem.
Posted on 2005-04-13
Here is what I'm trying to do:
1. I want to create a temporary table
2. fill that temporary table with data from an excel file
3. Then create a recordset from that temporary table.
The problem is that I'm actually coding this in an automation tool that uses VBA as its IDE, so I can't setup a connection to any database on the open recordset command. i.e. rst.open Source, Connection, CursorType, LockType, Options.
What do I use as a connection when I just want the data in the temporary table. Is there another way to get the data from the temporary table into a recorset without a connection defined?