Adding Excel Data to an Access Database

If you want to use a large or complex Excel worksheet in an Access database, you don’t have to reenter the data in order to use it in Access. You can simply import the data into Access and use it as you’d use any other Access table. When you import the data, you’re creating a copy of the Excel worksheet data. The imported data is independent of the original Excel workbook file, so any changes you make to the data in Access won’t change the information in the Excel file.

Get the Excel Data

  1. On the External Data tab in Access, with the database you want to use open, click the Import Excel Spreadsheet button.

  2. In the Get External Data Wizard, specify the Excel workbook you want to use; whether you want to place the imported data in a new table; whether you want to append to an existing table; and whether you want the data to be linked. Step through the wizard, specifying

    1. Which worksheet or named range is to be imported, and whether the first row contains column names.

    2. The destination of the table.

    3. The field name and data type for each column in the worksheet, whether the selected column is to be indexed, and whether the column should be included when the data is imported.

    4. The field for the primary key, if any, and the name of the new Access table.

  3. In the Navigation pane, double-click the new table that you imported to display it. Examine the table to verify that it’s correct, make any modifications you want, and then save the table.

    Get the Excel Data
    Get the Excel Data
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset