Database export
Datacap can export data to any DB2® , Microsoft Access, Microsoft SQL Server, or Oracle database by using the actions in the ExportDB library
Commonly used export actions are outlined in the following table.
| Library | Action | Description |
|---|---|---|
| ExportDB | ExportOpenConnection | Opens a connection to the specified export database. |
| ExportDB | SetTableName | Specifies the name of the table to which data is to be exported. |
| ExportDB | ExportFieldToColumn | Gets the value of the specified field on the current page and adds it to specified column in the internal data record. You build the record in memory before you commit it to the database by using AddRecord. |
| ExportDB | AddRecord | Inserts the assembled data record into the export table that is specified by the previous SetTableName action. |
| ExportDB | ExportCloseConnection | Closes an open export database connection. |
For a complete example, see Creating the ExportDB ruleset.