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?
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