ODBC Insert Table/Column Name

This dialog gives a list of table and column names for the currently selected table that can inserted into a text window, saving you from having to type them. Also appropriate delimiters (e.g. ‘Pay Day’) are added to names containing reserved characters (such as space ‘ ‘, percentage ‘%’, underscore ‘_’ etc.).

If you are inserting a table name, only the table list will be displayed. To select the table click on the table you required and click OK.

If you are inserting a column name, you must select the table which contains it to display it. To select the table click on the table name you require. The list of columns in this table will then be displayed in the column list. Click on the column you required and then click OK.

See also

SQL Statements
ODBC Databases
Create New Database Table from Spreadsheet
Insert Spreadsheet into Database
Merge Spreadsheet into Database
Run ODBC Export Link (GLK) file
Spreadsheet Export Menu
Spreadsheet Add Data Menu
Spreadsheet New Menu
Using ODBC with 64bit Windows
DBIMPORT procedure
DBEXPORT procedure

Updated on March 15, 2019

Was this article helpful?