exporting queries

[paulmcdonnell]

HI guys....

I want to export a query and create a new table in an external database through code.

Anyone have any examples of how to do this it's causing me som grief..

Thanks guys

Paul

 

[Old Gnome]

If your original query is a Create Table query, you should be able to copy the SQL code by highlighting the code, right click with the mouse, select copy....then paste into a new query in the new database.

Otherwise, can you give us some more details?

oldgnome

 

[donnycarr]

I have a similar problem, I am trying to run several queries using a macro within M/Access. I then want the results of these queries to be exported to an excel file. It just won't work. I think I am using the wrong instructions in the Macro design but I've tried every option.
Any help and advice would be great...!

...Donny