Is DSN-less connection to UPS WorldShip possible?

[jimfortune]

A long time ago in a company far, far away :-), I set up UPS WorldShip
to use an A97 query to provide up-to-date shipping label addresses
using a Data Source Name (DSN) created via the ODBC Administrator.
Now the shipping department at a different company that uses my
BillOfLading database would like to be able to have the main form
populate fields using the addresses that are stored locally within UPS
WorldShip. The business addresses from tblAccounts had to be adjusted
for things like loading docks, and the new information, including
multiple shipping addresses, was simply added as required to UPS
WorldShip. The shipping department has also grown accustomed to using
the UPS Worldship interface. It seems unnecessary to move all the
WorldShip data into an Access backend. So using Access to pull the
data from UPS WorldShip is where I'm headed. The recommendation in the
UPS WorldShip possibly out-of-date help file is again to use an ODBC
DSN. Is it possible to set up a DSN-less connection to the UPS
WorldShip data instead? The shipping department uses a single computer
for UPS WorldShip so a solution that uses any version of Access would
work since only a single upgrade would be required. Plus, for a single
computer, even using the ODBC DSN isn't that bad of an option if
necessary. I wanted to see if anyone here has done it before
contacting UPS.

James A. Fortune

[Douglas J. Steele]

What type of database does UPS use?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

<ji********@compumarc.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

A long time ago in a company far, far away :-), I set up UPS WorldShip
to use an A97 query to provide up-to-date shipping label addresses
using a Data Source Name (DSN) created via the ODBC Administrator.
Now the shipping department at a different company that uses my
BillOfLading database would like to be able to have the main form
populate fields using the addresses that are stored locally within UPS
WorldShip. The business addresses from tblAccounts had to be adjusted
for things like loading docks, and the new information, including
multiple shipping addresses, was simply added as required to UPS
WorldShip. The shipping department has also grown accustomed to using
the UPS Worldship interface. It seems unnecessary to move all the
WorldShip data into an Access backend. So using Access to pull the
data from UPS WorldShip is where I'm headed. The recommendation in the
UPS WorldShip possibly out-of-date help file is again to use an ODBC
DSN. Is it possible to set up a DSN-less connection to the UPS
WorldShip data instead? The shipping department uses a single computer
for UPS WorldShip so a solution that uses any version of Access would
work since only a single upgrade would be required. Plus, for a single
computer, even using the ODBC DSN isn't that bad of an option if
necessary. I wanted to see if anyone here has done it before
contacting UPS.

James A. Fortune

[jimfortune]

Douglas J. Steele wrote:

What type of database does UPS use?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

Thanks Doug,

That was the right question. I found some .CSV files and some A2K mdb
files in the WorldShip folders. I'll poke around until I find the
address info and just link to the CSV file or Access table, after
upgrading the A97 version if the addresses are found in an A2K table.

James A. Fortune

[ByteMyzer]

The main backend file for UPS Online WorldShip (upsdb.mdb) is in A2K format,
and it is in this file that all address information is stored. It will not
be possible for you to extract the address data from upsdb.mdb into your A97
format database, either directly or by DSN/DSN-less connection. You will
need to upgrade your A97 database to A2K.

<ji********@compumarc.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...

Douglas J. Steele wrote:

What type of database does UPS use?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

Thanks Doug,

That was the right question. I found some .CSV files and some A2K mdb
files in the WorldShip folders. I'll poke around until I find the
address info and just link to the CSV file or Access table, after
upgrading the A97 version if the addresses are found in an A2K table.

James A. Fortune

[jimfortune]

ByteMyzer wrote:

The main backend file for UPS Online WorldShip (upsdb.mdb) is in A2K format,
and it is in this file that all address information is stored. It will not
be possible for you to extract the address data from upsdb.mdb into your A97
format database, either directly or by DSN/DSN-less connection. You will
need to upgrade your A97 database to A2K.

How about this idea: Back up the entire WorldShip directory first,
copy the A2K upsdb.mdb file across the network to a machine with A2K,
export the file as Tab delimited back across the network as upsdb.csv,
then import into A97 to replace the A2K upsdb.mdb file in the WorldShip
directory with an equivalent A97 upsdb.mdb.

Has anyone ever tried anything like this?

James A. Fortune

[jimfortune]

ByteMyzer wrote:

The main backend file for UPS Online WorldShip (upsdb.mdb) is in A2K format,

That file may be the main backend, but it didn't seem to have the
addresses I'm searching for. I'll keep looking.

James A. Fortune

[jimfortune]

I don't know if I had the right upsdb.mdb before but I found the
addresses I need in an upsdb.mdb file. The table name was something
like calPkgAgent. Thanks.

James A. Fortune