A
Anya
Could anyone help me with the following?
I'd like to run several queries on a SQL server and create
a temporary table that would store the output from those
queries.
I would then want to place the output from that temp table
into an Access table. I can run the queries from VBA but
can't figure out how to write the output into the Access
table.
I can't create a regular "create table Access query"
because I'm pulling data from a temp table. I have to run
all the queries and create the temp table on the server
first because of the size of the tables: Access either
locks up or times out, even if I have time out set on 0
when I try to pull from the original tables directly.
Any ideas are greatly appreciated...
I'd like to run several queries on a SQL server and create
a temporary table that would store the output from those
queries.
I would then want to place the output from that temp table
into an Access table. I can run the queries from VBA but
can't figure out how to write the output into the Access
table.
I can't create a regular "create table Access query"
because I'm pulling data from a temp table. I have to run
all the queries and create the temp table on the server
first because of the size of the tables: Access either
locks up or times out, even if I have time out set on 0
when I try to pull from the original tables directly.
Any ideas are greatly appreciated...