Create a new table from existing data

Microsoft Access provides two ways to create a table from existing data:

• You can import or link data from another Microsoft Access database or data in a variety of file formats from other programs.
  
  
• You can perform a make-table query to create a table based on data in a current table. For example, you can use make-table queries to archive old records, to make backup copies of your tables, to select a group of records to export to another database, or to use as a basis for reports that display data from a specific time.

What do you want to do?

Create a table by importing or linking data

Create a new table using a make-table query