Export to Access Database

Use the Database > Export > Access Database menu option (EXPDB GX) to export data to a Microsoft Access database (MDB).

Export to Access Database dialog options

Output file	The output file name, .accdb assumed. Script Parameter: EXPDB.FILE
Channels to save	"D" for displayed channels. "A" for all channels. Script Parameter: EXPDB.CHAN
Lines/groups to save	"D" for the displayed line only. "S" for all selected lines. "A" for all lines. Script Parameter: EXPDB.LINE
Save lines to	Lines will be saved to the table "LineData" if EXPDB.SINGLE is set to "S" for single table output and to individual tables if it is set to "M" (for Multiple tables). Script Parameter: EXPDB.SINGLE: S: Single, M: Multiple tables

Application Notes

Either displayed data channels or all data channels may be exported, and the displayed line, selected lines or all lines may be exported. If the output file(s) already exist, they will be overwritten. New tables will be appended to an existing file, without altering previous contents.

The system offers you several choices for creating an Access database: You can either export worksheets (i.e. lines or groups) in a Geosoft database to individual tables or single tables. The following describes the options available for each.

Individual Tables (export as lines, groups, or lines and groups)

Lines	Each line has its own table in the output database. As a rule of thumb, if you are working with multiple lines, we recommend that you export lines as individual tables so that you can keep track of them in future. If you are working with a single line (i.e. geochemical data), it is more likely that you will export the line as a single table.
Groups	Groups (such as individual drillholes in a Target database) will be saved to individual tables in the external database.
Lines and Groups	If both lines and groups appear in the same Oasis montaj™ database, then only the type which is currently displayed will be exported. For instance, if a group is displayed, then only groups will be exported. If a line is displayed, only lines will be exported. If your database contains both lines and groups and you wish to save them to the same external file, you may do so by running the GX twice, once when displaying a group, and a second time while displaying a line.
Single Table	All lines are stored in one table called LineData in the output database. The table will contain a field named Line that contains the Line name strings of the entries in the database.