Data exchange between Excel and Access

Source: Internet
Author: User
Tags access database

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:
temporary
periodic
permanent

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.