Can you import data into Microsoft Access?

Question

You can import tables, queries, forms, reports, macros, or modules from one Access database into your current database. When you import an object, Access creates a copy of the object in the current database.

Can you import data into an existing Access table?

If your goal is to store some or all of your data from one or more Excel worksheets in Access, you should import the contents of the worksheet into a new or existing Access database. When you import data, Access creates a copy of the data in a new or existing table without altering the source Excel worksheet.

What file types can be imported into Access?

On the Add Tables page (the first thing you see when creating a new custom app), you can import data from other Access databases, Excel workbooks, ODBC data sources, Text/CSV files, and SharePoint lists.

Expert · Answer

If your goal is to store some or all of your data from one or more Excel worksheets in Access, you should import the contents of the worksheet into a new or existing Access database. When you import data, Access creates a copy of the data in a new or existing table without altering the source Excel worksheet.

Expert · Answer

On the Add Tables page (the first thing you see when creating a new custom app), you can import data from other Access databases, Excel workbooks, ODBC data sources, Text/CSV files, and SharePoint lists.

Can you import data into Microsoft Access?

Can you import data into an existing Access table?

What file types can be imported into Access?

Related Questions