Steps
- close the blank table
- select external data
- click textfile in import and link
- import text file
- click next
- select 'first row contains field name'
- next
- choose text for forename, surname, address line 1, address line 2, post code,phone number
- choose yes/no for allergy, deposit paid
- choose currency for amount paid
- choose date for date paid
- next
- let access add primary key if no unique field
- next then finished
- press home-view-design view
- format- click and scroll and chose correct one
- save