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
You can use Select Into query (make-table query) to do so
look at access help for more info

Signature
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com
> 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
[quoted text clipped - 3 lines]
> Thanks in Advance
> OS