The importation of data from MS Excel spreadsheet to MS Access table can be easily done by using Copy and Paste.

• It is of importance that the sequence of column headers in the worksheet is the same as the sequence of fields in the database table.

• It is also a good measure to count first the number of data rows in the spreadsheet to make sure that all the records in the worksheet will be imported into the database.

Here are the simple steps for importing data into MS Access:

1. Open the MS Excel worksheet needed for import. Highlight the data values excluding the column headers. Right-click selection and Copy.

• In the example spreadsheet, there are 31,311 records.

2. Open the MS Access table in the Design View, and select the entire row of the first record. Right-click and select Paste.

• MS Access will prompt the number of records that will be pasted in the table. This serves as a confirmation if all of the data from the spreadsheet will be imported into the database table. Click Yes.

• After pasting the records, Save the imported data into the database.