One way to create a new table in an Access database from information included in an Excel spreadsheet is to select the pertinent data on the spreadsheet, including the field names.
Copy the selection (Edit>Copy, or CTRL+C)
Switch back to Access .
With Tables objects being shown in the database window, choose Edit>Paste, or use the CTRL+V shortcut.
Access will ask if the first row contains the field names and then will paste the information as a new database table.
See all Topics