Spreadsheet Export Menu
See Also

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

Create Database Table

Add the spreadsheet as a new table in a database. See Create New Database Table from Spreadsheet 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.

See Also

ODBC Data Query - Select Data
SQL Statements
ODBC Databases
Spread Menu Commands
Spreadsheet Toolbar
GenStat Spreadsheet Contents