Microsoft Office Tutorials and References
In Depth Information
Import an Excel worksheet
Excel tables enable you to take advantage of basic
database features like sorting and filtering within
Excel. By importing worksheets into Microsoft Access,
you can better manage growing lists by taking
advantage of additional database features. As a
relational database, Access offers the benefits of
integrated wizard and design tools that enable you to
build customized forms, queries, and reports. Another
benefit is size. Unlike a workbook, a database is, for
practical purposes, limited only by the amount of
available disk space.
Before importing a worksheet into Access, you need
to format it as a table. Your columns may have
headings; however, you should try to eliminate blank
columns, rows, and cells. Exported Excel lists should
also avoid repeating information. For example,
instead of including a customer’s name and address in
every record of a transaction list, split the worksheet
into two lists: one with customer information and the
other with transaction information. The two lists
become, in Access, two tables linked by a key field.
Open an Access database.
Click the External Data tab.
Click Excel in the Import group.
The Get External Data — Excel
Spreadsheet dialog box appears.
Type the path to the file you
want to import.
Alternatively, click the Browse
button and locate your file.
The Import Spreadsheet Wizard
Click the worksheet you want to