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
CO2 Emissions per country
Calories for some foods
Formula 1 winners
Random set of surnames and marks (3 columns of marks)
Random set of surnames and marks (10 columns of marks)
330 Top earning movies in the USA
Chemical elements with Atomic Weight, Name, Symbol, Melting Point, Boiling Point, Density, Date discovered and Group
First 100 prime numbers
Sample of rainfall in mm for some South African towns and cities
Rand currency rate against some other currencies
Rand rate against the US dollar over a 6 month period
54 Longest rivers in the world with data in miles and km
International matches against South African rugby team
Names and details on some of the major stars
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)