How do I upload data from an Excel Spreadsheet into an Access Table?
The following Steps detail how to upload data from an Excel Spreadsheet into an Access Table Be sure that: • the first row of the Excel Spreadsheet contains the same headings as the database and that they are in the same sequence. • the field to be used as the key does not contain any duplicate data. • Within “File”, select “Get External Data”. • Click “Import” when the “Import” dialog box appears. • Using the “Look In” box select the Excel Spreadsheet. • Click “Next”. • On the resulting menu specify that the First Row contains the Column Headings. • Click “Next”. • On the resulting menu specify if you want the data stored in a new or existing table. • Click “Next”. • This menu allows you to specify information about each of the fields being imported. Its main use is to specify any fields that are not to be uploaded. • Click “Next”. • The resulting menu will allow you to specify the Primary Key. • Click “Next”. • The resulting menu will allow you to specify the name of the new table. •
