How to import data in Excel to the Access Database

How to import data in Excel to the Access database? How can I import the workbook data edited in Excel to the Access database? To import data in this way, you can do the following: 1. You need to adjust the data format and arrangement in Excel.

How to import data in Excel to the Access database? How can I import the workbook data edited in Excel to the Access database? To import data in this way, you can do the following: 1. You need to adjust the data format and arrangement in Excel.

　　HowPutDataImportAccessDataLibrary? Excuse meHowEdit the workbook in ExcelDataImportTo AccessDataLibrary? This method is implementedDataImport, You can do the following:

1. It needs to be adjusted in ExcelDataBecauseImportDataIn this way, the columns in the workbook are used as records under a field, and each row is a record. Therefore, you must ensure thatDataAre of the same type, and each row is sorted by fieldData.

2. EnableDataLibrary. Click "Get external" on the "file" menu.Data"Import"Command. In theImport"Dialog box, select" file type "as" Microsoft Excel ", and click" search range "to selectImport. Click"Import"Button,"ImportDataTable wizard dialog box, as shown in.

DataImportAccessDataDatabase ">

3. Select the worksheet in the workbook and click "Next. If the first row of the worksheet isDataYesDataLibrary field name, click to select the check box for "first line includes title.

4. If not, click "Next. Next, set the information to be savedDataTable NameDataSet each field in the database and create an index field. Click Finish.ImportProcess.

HowPutDataImportAccessDataLibrary original address: http://www.verydemo.com