To create a new table using an ODBC record definition
Select Application Files>Export Definition>ODBC from the main menu.
The ODBC Table Create window displays.
Enter the Data Source Name.
or
Select the up arrow and choose a Data Source from the Data Source Names window.
If you have not yet configured the DSN or to reconfigure a previously configured DSN, select Configure Data Source to access the ODBC Data Source Administrator window.
To export your record or field to MS Excel, do not select
MS Excel. Instead select MS Access Database. After the record is
saved in .mdb format, import the file into MS Excel.
Modify the Driver Connect String, if necessary.
ECMap creates a connect string based on the Data Source Name. Depending upon the database you use, you may need to modify the driver connect string to include a username and password. If you add them, the format of the driver connect string becomes:
DSN=<data source name>;UID=<username>;PWD=<userpassword>.
Select the application record from which you use as the format for the new ODBC table from the drop-down list.
The Table Name text box is populated with the table in which the record is located. You can change the table name.
In the current version of the software, if there is
a space in a record or field name, the table is not created. This
restriction applies only to exporting an ODBC record definition.
You can successfully import an ODBC record definition with a space
in a field name or a record name.
Select Continue, and the program creates the table. You return to the main ECMap window.
