Hello,
I'm trying to find out if it is possible within VBA in Access to export the results of a select type query in x database and place/import them as a new table in y database.
I do not want to copy the query design / the query its self but the results.
Currently I have found the following code and am led to believe this works but can't get the syntax right.
Set dbs = OpenDatabase("C:\*X_database_location*")
dbs.Execute "SELECT queryname.* INTO IN 'C:\*Y_database_location*'" FROM queryname, dbFailOnError
Can you please help?
Thanks,
Michael