Create Table From Query Access VBA

Question

I have a very complex query that pulls in information from ~10 tables, I'd like to then print those results to a table.

Here's my attempt:

DoCmd.RunSQL "CREATE TABLE [DATA OUTPUT TABLE] AS (SELECT * FROM [Data Export]);"

Where [DATA OUTPUT TABLE] is intended as the new table name and [Data Export] is the name of the query.

Schalton · Accepted Answer · 2016-07-21 16:10:41Z

5

DoCmd.RunSQL "SELECT * INTO [DATA OUTPUT TABLE] FROM [Data Export];"

answered Jul 21, 2016 at 16:10

Schalton

3,1345 gold badges37 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Works like a dream.