Creating new table using another table data.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create another table using the data from another table. Which
follows the structure of the previous table. Is there a way to do this using
SQL command in Access? I am exploring another way of doing this in a shorter
way not by creating a new table and inserting data into it. Thanks.
 
There are a number of options available for creating a table from existing
data, but as a general rule in Access it's better not to make full copies of
data.
Queries are great for extracting data when you need it, and you never need
to worry about keeping the two copies synched up.
 
Back
Top