Import Single Table

Use the Database > Import > Database Table > Single Table menu option (IMPDB GX) to import external file databases into a Geosoft database (GDB). The GX assumes that the database is a Microsoft Access database (with a .mdb file extension). If it is not, and the system can not identify its type, the system prompts you for it. The supported databases depend on the ODBC drivers that have been installed on the system.

Import Single Table dialog options

File to Import	Choose the file to import or type in an existing file name.
Selection	This can be one of the following options: Selected Table & Fields SQL Selection By choosing the 'Selected Table & Fields' option, a dialog will open to select a table (if more than one) and fields to import. By choosing the 'SQL Selection' option, a dialog will open to specify a SQL selection string and an Oasis montaj group name to create.

Application Notes

The following lists the typical ODBC drivers that come installed with a Microsoft Windows system:

• Microsoft Access Driver (*.mdb)

• Microsoft Excel Driver (*.xls)

• Microsoft dBase Driver (*.dbf)

• Microsoft Paradox Driver (*.db)

• Microsoft FoxPro VFP Driver (*.dbf)

• Microsoft Visual FoxPro Driver

If the "Specify coordinate system on import" setting is set to "Yes" in the General Settings, and if no coordinate system is defined in the current X and Y channels, the "Georeference Database Channels" dialog is called so that the projection can be set on the X and Y.