- 1). Log on to your computer and open Microsoft Access. Open the database you want to work with.
- 2). Click on the "File" menu and choose "Get External Data" from the list. Choose the "Import" option.
- 3). Change the "Files of type" setting to "Microsoft Excel" and click the "Import" button. Choose the "Show worksheets" option to see all of the worksheets within the Excel spreadsheet. Use the "Show named ranges" to select parts of those worksheets.
- 4). Click "Next" and check the "First row contains column headings" checkbox if appropriate. Click "Next" to continue.
- 5). Select the "New table" or "Existing table" option. Click the drop-down box to select the existing table if appropriate, then click "Next."
- 6). Type new field names if you wish, otherwise, accept the names as they exist. Click "Next" and select a primary key if you plan to use one. The primary key is unique to each record. Some examples include Social Security number, employee ID or product number.
- 7). Click "Next" and type a name for your table. Click "Finish" to complete importing the table.
- Advertisement -
- Advertisement -