Importing Csv Files to Access. Sharmeen Amir 11G1. Step 1. Open the Database you want to import the file in. Give your database a suitable name, and click on ‘Create’. Step 2. Select the ‘External Data’, and click on ‘Text File’ in that group. Step 3.
Select the ‘External Data’, and click on ‘Text File’ in that group.
On this screen, you’ll be asked to assign a primary key. Unless there is nothing unique, you click on ‘Let Access add primary key’, otherwise you click on ‘Choose my own primary key’.
Click next to continue.Step 7