CSVODBC
a program to integrate shipping software with your database
[Download]
Shipping
software such as UPS WorldShip can't update an existing table; it can
only insert a new record. This can be fixed if your database uses
triggers. If your database doesn't have that capability, you are out of
luck. That's where this program comes in. Just have your shipping
software export the data you require to a CSV file. This program will
watch for the CSV file to be created, read the data, and execute the
SQL command you specify against your database using the data from the
CSV file. The example SQL command in the screenshot above shows the
table 'Orders' being updated with data from from columns 2 & 3 of
the CSV file where the OrderNum matches column 1 of the CSV file.
See the included help file for more detail on setting it up.
Counter Reset November 3, 2018