In the Data folder, select a worksheet to export.
Select File > ODBC > Export > Legacy Wnl.
In the ODBC Export dialog, select the Create a new Export option button and press Next.
Create a new or load a connection string as detailed in “Establishing a connection”.
In the ODBC Export Definition dialog, select the Build a Definition option button and press Next.
As with the ODBC import, the schemas used to select the data variables can be specified. The Schema Filter dialog displays available schemas, if any were created by the database administrators.
If the Schema Filter dialog is displayed, select a schema and press OK.
Using schema filters can speed up export operations by using saved export files.
In the Table Name menu of the Field Selection dialog, select the database table to receive the exported data.
Drag the variables from the Variables list to the appropriate database fields under Field Definitions.
To export one constant value for all records in a given field, check the Fixed box for a variable and enter a value in the field name.
This method can be used to differentiate one export from another. The data type and field size are set by the database administrator.
Press OK.
In the Save Export? dialog, check the Save Password box to save the database username, password, and connection string in the export file.
Saving all three pieces of information in the import file allows connection to a database. The export definition file contains all information needed to reproduce the same export, excluding any constants in fixed fields.
Note: The import file is not encrypted, so the saved password is not secure.
Press Yes to display the Save As dialog for specifying the location and file name.
If you click Cancel in the Save As dialog, the worksheet is still exported into the database but the export file (*.exp) is not saved.