- Prepareyour data in an Excel spreadsheet and save as CSV type or XLS type. You takenote of the directory where it’s saved.

-  Create aNew Access Database. Unless you have an existing database that you use to storeproduct information, you're probably going to want to create a new databasefrom scratch. To do this, click on the Blank Database icon on the GettingStarted with Microsoft Office Access screen. Enter a database name, i.e.ProductImport and then click the Create button.

-  Start theExcel Import Process – click the External Data menu at the top of theAccess screen and double-click the Excel button to begin the Excelimport process.

- Choose theSource file and Destination file –

-  Click theBrowse button and navigate to the file you'd like to import. Once you'velocated the correct file, click the Open button.

- On the“Select the source and destination of the data” screen, you're presented withimport destination options. In this instance, we're interested in converting anexisting Excel spreadsheet to a new Access database, so we'll choose " Importthe source data into a new table in the current database."

- Once you'veselected the correct file and option, click the OK button to continue.

- SelectColumn Headings – Normally, the first row of your Excel spreadsheet is used toprovide column names for your data. For example, Department name, CatalogNumber, Product Name, Product Intro, Product Description, Image, etc. columns.Ensure that the " First Row Contains Column Headings " box isticked. This will tell MS Access to treat the first row as field names, ratherthan actual data to be stored in the product data. Click the Next button to continue.

-  Select aPrimary Key – you can use Catalog Number as your primary key (ensure that yourCatalog Number is unique)

- Name YourTable – You need to provide Access with a name to reference your table. Forexample, you can call your table "Products." Enter this into theappropriate field and click on the Finish button.