How to Import a Selected Range of Cells Into Access From Excel 2003

1. Open the Excel 2003 spreadsheet that you want to import. Drag your cursor along the record selection buttons to the left of your cells until you encompass the intended records. Press 'Ctrl' and 'C' to copy the records, select another tab in your spreadsheet and press 'Ctrl' and 'V' to paste.
2. Label the second tab with a description so that you can recognize it from Access. Save your Excel spreadsheet after making all of your changes. Close your Excel spreadsheet and open the Access database.
3. Click the 'External Data' tab of the ribbon at the top of the page and select 'Excel.' If you are using Access 2003, click 'File,' then 'Get External Data' and then 'Import.' Locate the Excel spreadsheet saved on your computer and choose whether to add it to a new table or an existing table.
4. Choose the tab with the selected records out of the worksheet options in the import wizard. This option allows you to import single sheets from the same Excel file. Instead of needing to create a new spreadsheet for certain information, you can simply choose a certain sheet.
5. Specify the fields you want to import and the primary key if you're creating a new table. If your records don't have an appropriate field, Access can create a primary key field for you. Name the table and complete the import wizard.