Starting point of this tutorial is Xml\Tutorial\1001 Managing script data\External table mappings\Datatable.LoadExternal.Odbc.Expression.xml


Tip! ScriptoMate associates Import with files, and Load/Save/Link with database tables

1. Open the document with the missing external table mapping

The example diagram refers to an external table mapping [Transactions] that doesn't exist yet (hence the error). This mapping will be created in this tutorial.


2. Create a new external table mapping

Click the [Maintain external database tables] button in the toolbar


The [Maintain external database tables] window is displayed.

Click the [Add external database table] button

A new external table mapping is added to the document, with default values ([Name] = New external table, [Destination table] = OUTPUT)

Change the [Name] of the mapping to Transactions

Click the [Apply] button



Select the mapping that was just created (Transactions)

Click the [Preview] tab and then [New]



3. Specify the external table parameters

The [Set external table specification] window is displayed

Set the values as indicated below ([Driver] = ODBC, [Connection string] = Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=D:\Data\Tabular.Transaction.Odbc.accdb;Uid=Admin;Pwd=;, [Table] = Transaction, [Data table] = OUTPUT)

Click the [Apply] button



4. External table load preview

The [Set external table specification] window is closed, and the [Maintain external database tables] window is visible again

Review the preview for the load. If required, repeat step 3 until the external table load suits your needs.



From the [Actions] toolbar a mapping can be added, deleted, or duplicated


5. Adjust the import destination parameters

Click the [Definition] tab

Change the destination parameters

Click the [Apply] button



6. The design time error is resolved

ScriptoMate detects that the external table mapping exists, and removes the design-time error