Technology Education Alumni Database

Database Logo

Opening exported data in Microsoft Excel
  1. Remember where you saved the alumni.csv file
  2. Start Microsoft Excel
  3. Go to File|Open or hit Ctrl+O
  4. Select "Text Files (*.prn; *.txt; *.csv)" in the "Files of type:" dropdown
  5. Navigate to the directory where you saved alumni.csv
  6. Click on alumni.csv in the file list and click Open
  7. The data will now appear in an Excel worksheet; the column headers are in row 1
Opening exported data in Microsoft Access
  1. Remember where you saved the alumni.csv file
  2. Start Microsoft Access
  3. Create a blank database or open an existing one
  4. Click on the Tables tab in the database window, then click New
  5. Select Import Table, then click OK
  6. Select "Text Files (*.txt; *.csv; *.tab; *.asc)" in the "Files of type:" dropdown
  7. Navigate to the directory where you saved alumni.csv
  8. Click on alumni.csv in the file list and click Import
  9. Select Delimited, then click Next
  10. Select Comma, and choose " in the Text Qualifer dropdown
  11. Check "First Row Contains Field Names", and click Next
  12. Select "In a New Table", and click Next
  13. On the next page, modify the fields if desired, then click Next
  14. Select "Let Access add Primary Key", and click Next
  15. Name the table you are exporting the data to, and click Finish
  16. The data will now be in an Access table
Opening exported data in Gnumeric
  1. Remember where you saved the alumni.csv file
  2. Start Gnumeric
  3. Go to File|Import
  4. Navigate to the directory where you saved alumni.csv
  5. Click on alumni.csv in the file list and click OK
  6. Select "Text File import" and click OK
  7. Select Seperated, Trim Always (Both sides), import all lines, and click Next
  8. Select Comma (,) as separator, uncheck "See two separators as one", check "Adjacent quotes escaped, choose " as the text indicator, and click Next
  9. Click Finish
  10. The data will now appear in the Gnumeric worksheet; the column headers are in row 1

[ Back to Database Administration ]