Geochemistry Database Import Wizard - Step 1 of 2

Use this wizard dialog to specify the database table and field parameters for the database file that is to be imported into a Geochemistry database.

Geochemistry Database Import Wizard (Step 1 of 2)

Select Database Table
Database Table	Using the drop-down list, select the database table for import.
Database Fields	The database fields that are available for import. Select (highlight) a field to specify the Channel Type and Parameters.
Next>	Click the Next> button to continue the import process.

Important Note for Excel Database (XLS) Import:

The Microsoft ADO software that we use to read and import XLS files only scans the first 20 rows or so of the data. It then makes a decision about the type of data based on what it sees (it will generally ignore the first row because it is used for titles, etc.)

If there is no data in the first 20 rows of a column, it assumes all values are type "string". This would be fine, but any actual values stored numerically are no longer picked up by the ADO software, and are reported to Oasis montaj as being "VT_NULL" type, that is, blank.

Therefore, to ensure that a numerical column in Excel is imported, there MUST be a value in the first 20 rows or so.

The numeric type entered in the wizard (e.g. string/float) controls only the type of the channel created in the database; it has no effect on whether the data will be recognized or picked up during the import.

We have tried to get around this Microsoft limitation, but with no success.

The workaround is either to re-order the original data so that there are data values in the first 20 rows, or to export to another format (example CSV) and import it that way.