Can I create a table by running a query?

  • Thread starter Thread starter David
  • Start date Start date
D

David

Can I create a table by running a query?

I have redesigned a system by creating a set of linked
relational tables from a single table.
Now I need to write a routine to transfer the data from
the old tables to the new tables. Most of this will be
done by running a series of queries to create several
temporary tables. These tables will then be read to create
the final set of linked tables.
 
You can make tables by running make-table queries. If you
already have the tables made, you can populate them with
data using append queries.
 
Have you tried the Table Analyzer available in the Menu

Tools / Analyze / Table

which can do most of the steps mentioned for you?

HTH
Van T. Dinh
MVP (Access)
 
Back
Top