Save to Access format using macro

T

theintern

I'd like to have my macro filter a table and save the results as an different
access table. I have the filter working, but is the saving part possible?
In the OutputTo fxn, access format isn't an option.

Thanks
scott
 
S

Steve Schapel

Scott,

You could make a Make-Table Query, and then use an OpenQuery action in
your macro to activate it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro SetWarnings (Access 2003) not working 2
access 2007 output table to csv 2
Use a macro to export a table to Excel 1
Output Query Results to a Text File 1
How can I filter by macro in access 2007? 1
Output File Naming 8
MS ACCESS 2013 Long Text filed filter by another tables Long text field 1
Microsoft Access can't start the OLE Server 0

Top