Importing a CSV file into Access

First of all, create the CSV files from the table in Excel simply by saving all three worksheets as three Comma Sepearted Variable files.


Next, after creating a blank database in Access, click File > Get External Data > Import... Then select one of the CSV files that was saved earlier. The box below should appear.


Make sure to select a Delimited format, as this this the format that CSV uses. Also ensure at this stage that you have selected the correct data to import.


Now select 'Comma' as the delimiter and make sure that the 'First Raw Contains Field Names' checkbox is checked.


In the next step, specify that the data should be placed in a new table.


This step lets you specify the type of data for each field.


This is the final step. It lets you choose a primary key to identify each record in the table. The table will be created after this step.