Exporting to a Database

Pocket PC Creations can export data sets to a database, provided that it is accessible via an ADO driver.

To export data to a database:

1. To export a limited set of data, select data in the Data Window. To export all data, this will be an option later in the process.
2. Choose the Export To option from the Data menu, and then choose Database...
3. Select a complete or selective export, and click OK.
4. Type an ADO connection string for the database you wish to use, or alternatively, open a Microsoft Access .mdb file.
5. Select the table and fields to populate with Pocket PC Creations data, and click OK.

Note that this process may vary slightly depending on the nature of the database exporting to. There may be prompts for additional information necessary to access and modify the database.

After the successful selection of a data source, the field mapping dialog will appear. If the data source needs to be reconfigured at any time, it can be modified via the "Database..." button.

In some databases, a list of available tables will appear in the "Table Name" selection. Select the table to store results in, or enter the name of the table manually if need be.

Once a valid table name has been entered, a list of fields in the table will appear in the right-most list under "Table Fields". To the left under "Project Fields" is a list of points in the project that can contain data. To create a mapping between a Pocket PC Creations point and a field in the table, first select the point from the left list. The previous mapping, if any, will be selected in the right list. Click on a new field in the right list to change the mapping.

Note the "Guess Mapping" button can be used to attempt to automatically create a mapping between the project and the fields in the table, by matching point names with field names. It will report which points were mapped successfully.