sql - Create Table From Query Access VBA -

http://www.techonthenet.com/sql/tables/create_table2.php

i have complex query pulls in information ~10 tables, i'd print results table.

here's attempt:

docmd.runsql "create table [data output table] (select * [data export]);" 

where [data output table] intended new table name , [data export] name of query.

almost found answer: http://www.w3schools.com/sql/sql_select_into.asp

docmd.runsql "select * [data output table] [data export];"