UPS Worldship integrations can be quite easy, but I have found that when integrating it with MS Access, the date format that is exported does not play well with an Access date field. The error I received is the following...
ODBC Error: State= 22005 Error. Invalid character specification (null).
The trick to making this work is to change your field type in the Access table from a date formated field to a text field. Then you will need to change the text date into something that resembles a date format and then move it to a table that uses a date field.
Now I am able to append my Access table with each shipment processed to provide our AJ Manufacturing sales staff with tracking numbers.
