Access 2003. Send Query as a Table

ggodwin

Registered User.
Local time
Today, 07:42
Joined
Oct 20, 2008
Messages
112
I have a database query that I would like to send to another database in another location.
currently I am using the below code. However, this is sending the query as another query. I know I can change this to a make table query and then send a table as a table.
However, if possible I would like to send the query results as a table.
The below code is sending the query "qQreValueQreUpdateTMMKVEH" as a query. Can I make it into a table instead?


Code:
DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\Documents and Settings\dsggodwin\Desktop\temp_QRE_Tables\qualitymanagement2009.mdb", acQuery, "qQreValueQreUpdateTMMKVEH", "QREVALUETMMKVEH", False
 
even if you can, why not just send it as a table after making it one? It might save you some "wondering". :)
 

Users who are viewing this thread

Back
Top Bottom