Spreadsheet Export Menu

This menu allows the contents of a spreadsheet to be exported to an ODBC database or Excel file.

Create Database Table

Add the spreadsheet as a new table in a database. Before the dialog appears, you will be prompted to choose the ODBC Database to add the tables to using the Select ODBC Database dialog. See Create New Database Table from Spreadsheet for more details.

Create Mutiple Tables

Add multiple sheets in a spreadsheet as new tables in a database. Before this dialog appears, you will be prompted to choose the ODBC Database to add the tables to using the Select ODBC Database dialog. See Export Multiple Tables to a Database for more details.

Insert into Database Table

Insert the spreadsheet rows as new rows in an existing table in a database. See Insert Spreadsheet into Database for more details.

Merge with Existing Database Table

Use the data in the spreadsheet to update existing rows in an existing table in a database. The rows which are updated are specified by matching the values of specified columns. See Merge Spreadsheet into Database for more details.

Run Saved ODBC export link

Use the specification from an existing ODBC export link file (*.GLK) to update a table in ODBC database using Insert or Merge. An export link file can be saved when running the interactive Export, Insert or Merge menus above. See Run ODBC Export Link (GLK) file for more details.

Add to Excel file

For convenience, you can add sheets to an existing Excel file without having to open that file. This lets you collate the output from a sequence of related analyses, adding each spreadsheet in turn when you’ve finished working with it.

Add to Book (GWB) file

For convenience, you can add sheets to an existing .gwb workbook without having to open that book. This lets you collate the output from a sequence of related analyses, adding each spreadsheet in turn when you’ve finished working with it.