Import

Hi Katherine,

Welcome to the forum, Thank you for your post.

In answer to your question:

1. Make sure the Microsoft Excel data is in list format: each column must have a label in the first row and contains similar facts, and there are no blank rows or columns within the list. (Blank row or column means end of data)
2. Close the Excel workbook that contains the data you want to use in Microsoft Access.
3. In Access, open the database where you wish to copy the Excel data.
4. On the Access File menu, >Get External Data, and then click Import.
5. In the Import dialog box, change to Microsoft Excel in the Files of type box.
6. In the Look in list, navigate to the file you want to import, and then double-click the file.
7. The Spreadsheet Import wizard will open, follow the steps as indicated.

I hope that has helped, regards Pete