Can a SQL data source be used with Transaction Pro Importer?
To connect to a SQL data source, follow the steps below:
In Importer, choose DSN for the file source and then click CONNECT
Select the MACHINE DATA SOURCE tab
An error message will appear that says it cannot create a system DSN due to insufficient permissions -click OK
Go through the Wizard, selecting the SQL Driver
Click FINISH to setup the driver
The SQL tables should now be visible in Importer