IMPORT QUERY - Help!!!

G

Guest

The import screen allows you to import a query as a table. The feature is
under <Options>, on the import screen. How can I import a query result set
as a table in vba?

Thanks in Advance
OS
 
A

Alex Dybenko

You can use Select Into query (make-table query) to do so
look at access help for more info
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Text Import Specification Missing 3
How to export table from outlook into ms access table? 0
VBA code to import table via query 1
Access Table Import with VBA 2
Access Import & Link section grayed out MS Access 2010 1
Import crosstab query as a table using code 4
Import CSV tables 5

Top