How do I migrate data from a query to a table

E

Elias Alli

I need to do this because I have created a table out of
two existing tables and I need to migrate the data in
their...I have populated a query(join) with the
data ..cause of previous problems I have decided to create
a table and populate it with the data from these two
tables as the database should not have been further
normalized
 
J

John Vinson

I need to do this because I have created a table out of
two existing tables and I need to migrate the data in
their...I have populated a query(join) with the
data ..cause of previous problems I have decided to create
a table and populate it with the data from these two
tables as the database should not have been further
normalized
Click to expand...

Change the query to an Append query and append it to the new table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Creating a Chart on form from selected data in query. 0
How to have two tables on same line? 1
How do I migrate Outlook 2007 to Outlook 2019? 0
How do I clear a form? 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Migrating from 2010 to 2013 - having issues: Exporting to xml 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0

Top