- 1). Save your Microsoft Excel spreadsheet in a format that is compatible with your Access database. If using Microsoft Access 2003, save your Excel spreadsheet in a 2003 format as well. This compatibility ensures that all of your data is preserved through import.
- 2). Click on the "External Data" tab of the ribbon at the top of the page. If the ribbon is minimized, right-click on the dark blue line and deselect "Minimize Ribbon." Under the "Import & Link" menu, select the "Excel" button to begin the import wizard.
- 3). Click on the "Browse" button and locate the Excel file you want to import. Select whether you want to import the spreadsheet into an existing or as a new table in your Access database. Choose which sheet of the Excel file you want to import.
- 4). Determine the "Primary Key" of your Excel file if you are creating a new table. This field helps the database locate records in your tables, and each record should have a unique value in its Primary Key field. If nothing is acceptable, Access can create a new primary key field.
- 5). Set the first row as column headings if you are creating a new table. If your Excel spreadsheet does not contain columns headings, you can always set them in the table's "Design View." Name your table with a strong description to locate it in the future.
- Advertisement -
- Advertisement -