Download
1 / 13
150 likes | 380 Views
Importing a CSV file…. By: Asma, 11G1. How to import a CSV file??. Go to ‘start’, and click on ‘all programs’. Click on Microsoft Office, then on Microsoft Office Access 2007,.
E N D
Importing a CSV file….. By: Asma, 11G1
Click on Microsoft Office, then on Microsoft Office Access 2007,
When the database page has loaded, click on ‘Blank Database’, then provide your database with a file name and browse for the place where you need to store them; through the folder icon and then click on ‘Create’.
Once it is created, click on ‘External Data’ (an icon at the menu bar) and then click on ‘Text File’,
Then it will open a page asking to browse the file that you want to import. After browsing click on ‘Open’, and then ‘Ok’,
After that ‘Import Text Wizard’ opens; You do not need to change anything on the first step,
After clicking ‘Next', on the second step; Just click on the box that says ‘Field Row Contains Field Names’, and then click on ‘Next’,
Here, you have to alter your field types if it is text or number etc. and then click on ‘Next’,
On the next step ,that is to choose or identify yourprimary key. Just click on ‘Choose my own Primary key’ that is my ID card no. and then click on ‘Next’,
As of you come to the last step just click on ‘Finish’ and then ‘Close’ ,without making any changes.
