create table (structure) from query (MS-Access)

Question

I like to create an empty table from a (pivot) query in Microsoft Access (using Office 365 1902). With the help of this post I found a solution with one shortcoming:

SELECT TOP 1 * INTO tblNew FROM qryMyQuery;

The shortcoming is that tblNew contains one record which needs to be deleted to get an empty table. Access 365 can not process SELECT TOP 0 * INTO.

I post this primarily because other people may have the same question and run into the same problem. I can work with my solution, but maybe somebody has a better one?

Erik A · Accepted Answer · 2019-03-08 20:54:20Z

1

The solution is very simple:

SELECT * INTO tblNew FROM qryMyQuery WHERE False;

Since the WHERE condition matches 0 rows, 0 rows get copied.

edited Mar 8, 2019 at 20:54

answered Mar 8, 2019 at 19:50

Erik A

32.8k13 gold badges48 silver badges74 bronze badges

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

Collectives™ on Stack Overflow

create table (structure) from query (MS-Access)

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related