Transfer+of+data+between+databases+and+other+applications+(eg.+Import,+export,+.csv+files)+–+MIKE


 * __Transfer of data between databases and other applications.__**


 * __Example:__**

If JESS wanted to take all the student data from the current database, SIMS (Security Information Management System) and import it to an upgraded database program such as ISAM (Indexed Sequential Access Method) they would have to follow a certain procedure to maintain the structure and format of the data while transferring it.


 * __Procedure__**

Export the file from your database as either an excel file or a comma separated values file. Easily done by selecting export and save as either ‘.xls’ or ‘.csv’ Exporting as ‘.xls’ or ‘.csv’ keeps the format of the data. Excel as it’s a database file type consisting of rows and columns/ fields and records. Comma Separated Values as it is a widely compatible file type. Open the new database and select import. As long as the data is in the correct format the data should create a table exactly the same as the exported.


 * __CSV__**

The comma-separated values (CSV) and it is a file type used to store tabular data in which numbers and text are stored in plain-text form that can be easily written and read in a text editor.

In CSV files, a comma separates each field and each line separates each record. The first line of a CSV file always contains the field names/titles.


 * __Example:__**

Year,Make,Model,Length 1997,Ford,E350,2.34 2000,Mercury,Cougar,2.38

This data above imported into a database would give this outcome:


 * Year || Make || Model || Length ||
 * 1997 || Ford || E350 || 2.34 ||
 * 2000 || Mercury || Cougar || 2.38 ||

Transfer of data between excel & access tutorial. http://www.youtube.com/watch?v=1vByEbrQW04 media type="youtube" key="1vByEbrQW04?rel=0" height="315" width="560"

Mike Cowie