Copy, import, and export data between Excel and Access

Source: Internet
Author: User
There are multiple data exchange methods between Microsoft Office Access and Microsoft Office Excel. To load Access data into Excel, you can copy and paste the data from the Access data table to the Excel worksheet, connect to the Access database from the Excel worksheet, or export the Access data to Excel.

There are multiple data exchange methods between Microsoft OfficeAccess and Microsoft OfficeExcel. To load Access data into Excel, you can copy and paste the data from the Access data table to the Excel worksheet, connect to the Access data library from the Excel worksheet, or export the Access data to Excel.

There are multiple exchanges between Microsoft OfficeAccess and Microsoft OfficeExcelData.
·DataTo load the Excel file, you canDataTableCopyDataPaste it into the Excel worksheet and connect to Access from the Excel worksheetDataLibrary, orDataExportTo an Excel worksheet.
·DataMount Access, which can be from an Excel worksheetCopyDataAnd paste it to AccessDataIn the table, convert the Excel worksheetImportAccess table, or link to an Excel worksheet from the Access Table.
  Note
·"ImportThe word "has different meanings in Excel and Access. In Excel,ImportCreates a refresh permanentDataConnection. In Access,ImportTheDataLoad Access once, but do not createDataConnection.
· You cannot save an Excel Workbook as an AccessDataLibrary. Neither Excel nor Access can use ExcelDataCreate AccessDataLibrary.
  Use Access in ExcelData
IfDataIn Access, but you want to useData:
Operation:Nature of exchange:Set AccessDataCopyIn Excel, temporarily add AccessDataExportTo Excel, regularly connect to Access from ExcelDataPermanent
  Use Excel in AccessData
  IfDataIn Excel, but you want to useData:
Operation:Nature of exchange:Convert ExcelDataCopyTo Access the temporary ExcelDataImportAccess regularly links from Access to ExcelDataPermanent

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.