Click here to Skip to main content
15,895,011 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
How to convert a query's output record to a new table's records in Access?

Thanks In advance
Posted

1 solution

If the table doesn't exist then
SQL
SELECT Table1.[ID], Table1.[Field1], Table1.[Field2], Table1.[Field3] INTO Table2 FROM Table1;
If the table already exists then
SQL
INSERT INTO Table2
SELECT Table1.[ID], Table1.[Field1], Table1.[Field2], Table1.[Field3]
FROM Table1;

I switched to SQL View to do this. Sorry I don't know how to do it in Access' Design View
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900