Data exchange 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:	Nature of the Exchange:
Copy Access data to Excel	Temporary
Export Access data to Excel	Regular
Connect to access data from Excel	Permanent

Working with Excel data in Access

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

Operation:	Nature of the Exchange:
Copy Excel data to access	Temporary
Import Excel data into Access	Regular
Linking to Excel data from Access	Permanent