5. Transfering data between applications

In order to transfer data between two applications with no common format you will need to follow a process.

The generic process is described below:

1. Data needs to be exported from the first application Into a common file format e.g. .csv

2. The common file format is then imported into target application

3. The data in the file is converted into a format that can be used by the target application

4. The new file is saved into the new format

A worked example: Transferring data from a spreadsheet into a database application

1. The data in a spreadsheet is will be saved as a .csv file (common file format). The spreadsheet and csv file are closed

2. The database application is opened and the common file format (csv file) is then imported into the database table.

3. An option is marked to indicate that the data is in csv format. The database application then converts the csv data into a format which is usable by the application.

4. The database is saved as a .mdb file