1 / 13

Importing a CSV file…..

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,.

rudolf
Download Presentation

Importing a CSV file…..

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Importing a CSV file….. By: Asma, 11G1

  2. How to import a CSV file??

  3. Go to ‘start’, and click on ‘all programs’

  4. Click on Microsoft Office, then on Microsoft Office Access 2007,

  5. 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’.

  6. Once it is created, click on ‘External Data’ (an icon at the menu bar) and then click on ‘Text File’,

  7. Then it will open a page asking to browse the file that you want to import. After browsing click on ‘Open’, and then ‘Ok’,

  8. After that ‘Import Text Wizard’ opens; You do not need to change anything on the first step,

  9. After clicking ‘Next', on the second step; Just click on the box that says ‘Field Row Contains Field Names’, and then click on ‘Next’,

  10. Here, you have to alter your field types if it is text or number etc. and then click on ‘Next’,

  11. 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’,

  12. As of you come to the last step just click on ‘Finish’ and then ‘Close’ ,without making any changes.

  13. Your step on ‘how to import a csv file’ is done.

More Related