Sample data for MS Access or Delphi
 


This page lists files in CSV (Comma Separated Values) and TXT (text) format that can be used as data in Delphi programming as well as imported data for a database program such as MS Access.

Rugby Super 14 Statistics 2007
2007super14.csv
2007super14.txt

CO2 Emissions per country
CO2Emissions.csv
CO2Emissions.txt

ASCII characters
ascii.csv
ascii.txt

Calories for some foods
calories.csv
calories.txt

Fibonacci numbers
fibonacci.csv
fibonacci.txt

Formula 1 winners
formula1.csv
formula1.txt

Random set of surnames and marks (3 columns of marks)
marks.csv
marks.txt

Random set of surnames and marks (10 columns of marks)
marks10.csv
marks10.txt

330 Top earning movies in the USA
movies.csv
movies.txt

Chemical elements with Atomic Weight, Name, Symbol, Melting Point, Boiling Point, Density, Date discovered and Group
periodic.csv
periodic.txt

First 100 prime numbers
prime.csv
prime.txt

Sample of rainfall in mm for some South African towns and cities
rainfallmm.csv
rainfallmm.txt

Rand currency rate against some other currencies
randrates.csv
randrates.txt

Rand rate against the US dollar over a 6 month period
randusd.csv
randusd.txt

54 Longest rivers in the world with data in miles and km
rivers.csv
rivers.txt

International matches against South African rugby team
sarugby.csv
sarugby.txt

Names and details on some of the major stars
stars.csv
stars.txt
 

Steps to import a CSV file into MS Access (version 2000):

1) Create a blank database file and give it a name
2) Go to: File > Get External Data > Import
3) Choose 'Text Files' next to Files of type
4) Locate text files (CSV) on computer and click on Import
5) In the Import Text Wizard - make sure Delimited option is selected
6) Click on 'Next >'
7) With CSV files make sure the 'Comma' is selected as delimiter
8) Tick 'First Row Contains Field Names' if relevant
9) Click on 'Next >'
10) Choose 'In a new table' - unless data is imported into an existing table
11) Click on 'Next >'
12) Change data types or discard any fields if necessary
13) Click on 'Next >'
14) Select or add primary if necessary
15) Click on 'Next >'
16) Give/change name
17) Click on 'Finish'
18) Before using (or opening in Delphi) open the table in MS Access and view it in 'Design View'
19) Adjust the field size of the Text fields to an appropriate amount - it is set to 255 by default
20) The table can now be saved and be used in MS Access or opened in Delphi

 






Return to Home Page

© JAK Olivier (2008)

Website: http://www.jako.nom.za/
E-mail: olivier@teachitza.com