I am trying to modify my access-based accounting program to be able to access the UPS website for their freight rates. I want to take my customer's zip code along with the products weight and get realtime freight charges from the UPS website.
Novice
Windows 7 64bit 
Access 2010 32bit
I am trying to modify my access-based accounting program to be able to access the UPS website for their freight rates. I want to take my customer's zip code along with the products weight and get realtime freight charges from the UPS website.
Moderator
Windows XP Access 2003
Have you talked to UPS support? Or studied their technical literature?
Sometimes Helpful
Windows XP Access 2003
Have you tried creating an InternetExplorer.Application object? I am going to guess that there will be quite a large amount of code to automate your request. Not sure if they offer an API or not.
VIP
Windows 7 64bit Access 2010 32bit
If they don't offer an API, alternative is webpage 'scraping'.
Review:
https://www.accessforums.net/general...ase-27053.html
https://www.accessforums.net/access/...ext-37032.html
https://www.accessforums.net/forms/a...ata-29837.html
Thread re a web API https://www.accessforums.net/forms/a...her-34620.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Access VB download Excel file from website
Posting Permissions
Reply With Quote