Copy, and export data between Excel and Access

There are several ways to exchange data between Microsoft Officeaccess and Microsoft Officeexcel.

• To load data from Access into Excel, you can copy data from an Access data table and paste it into an Excel worksheet, connect to an Access database from an Excel worksheet, or export Access data to an Excel worksheet.

• To load data from Excel into Access, you can copy data from an Excel worksheet and paste it into an Access datasheet, import an Excel worksheet into an Access table, or link to an Excel worksheet from an Access sheet.

Comments

·“ The word import has different meanings in Excel and access. In Excel, an import refers to establishing a permanent data connection that can be refreshed. In Access, importing means loading data into Access once, but not establishing a data connection.

• You cannot save an Excel workbook as an Access database. Excel and Access do not provide the ability to create an Access database using Excel data.

　　working with Access data in Excel

If the data is in access, but you want to use that data in Excel:

Operation: The nature of the exchange:

Copy Access data to Excel temporarily

Export Access data to Excel on a regular basis

Connect to access data from Excel permanently

　　working with Excel data in Access

If the data is in Excel, but you want to use that data in Access:

Operation: The nature of the exchange:

Copy Excel data to an interim in access

Import Excel data to Access regularly

Linking to Excel data from Access permanently