![Picture](/uploads/2/4/3/6/24362712/4490716.png)
1. Create a new database- give it a sensible, save it in your IGCSE folder.
2. Click 'external Data'
2. Click 'external Data'
![Picture](/uploads/2/4/3/6/24362712/4920672.png)
3. Click the button 'text File' in the IMPORT section of the ribbon.
4. Step through wizard, don't forget to tick 'First row contains field names'
4. Step through wizard, don't forget to tick 'First row contains field names'
![Picture](/uploads/2/4/3/6/24362712/1723898.png)
5. Check your data types against the question.
6. If any of the fields are 'unique' then select it as the primary key!
6. If any of the fields are 'unique' then select it as the primary key!
![Picture](/uploads/2/4/3/6/24362712/3382187.png)
7. when finished check you have only ONE new table. Any called 'import errors' means you must close and delete all tables before starting again.
8. When the table is successful imported, open it and check for design errors.
9. Go into design view and make any FORMAT changes as necessary.
8. When the table is successful imported, open it and check for design errors.
9. Go into design view and make any FORMAT changes as necessary.