IPA and MS-Access DB

Yes, it is possible. These instructions are how to retrieve data to be used by a third-party shipping software:

Part 1: Setup an ODBC connection to SQL database
Part 2: Create the MS Access file
Part 3: Setup a second ODBC connection to the MS Access file

--------
Part 1: Setup an ODBC connection to SQL database
Launch ODCB Data Source Administrator in 32-Bit mode (C:\Windows\SysWOW64\odbcad32.exe) as an admin.
Select the "System DSN" tab
Click "Add...""
In the Create New Data Source window, select "SQL Server." Click next.
On the next screen, enter the Name, description (optional) and the SQL Server url. Click next.
Check the second option "With SQL Server authentication....."
Check "Connect to SQL Server to obtain....."
Enter a Login ID and password (Login ID used will depend on if you need read/write or read-only, check the Login Id's permissions).
Click next.
Check "Check the default database to" and select a default database you wish to use. Click Finish.
Click Finish.
Click "Test Data Source...", if successful, you're good to go on this part. Click ok. and OK again. If not successful, check your Login credentials, and repeate the steps above.
For ease of setup, leave the ODBC Connection program open.

------
Part 2: Create MS Access database file:
Open MS Access.
Create a new blank database, File > Save as, name it and should be saved as "[your filename here].accdb".
Go to the External Data Tab.
Select New Data Source > from Database > From SQL Server.
In the "Get External Data" window, select "Link to the data source by creating a linked table" .
In the "Select Data Source" window, under the "Machine Data Source" tab, select the OBCD connected created in Part 1.
Click OK.
A list of tables will appear. Select individual tables, or all depending on what you're trying to achieve.

-------
Part 3: Setup an ODBC connection to the MS Access file:
If not already open, launch ODCB Data Source Administrator in 32-Bit mode (C:\Windows\SysWOW64\odbcad32.exe) as an admin.
Select the "System DSN" tab.
Add...
In the Create New Data Source window, select "Microsoft Access Driver(*.mdb, *accdb)" Click Finish.
On the next screen, enter the Name and description.
in the Database section Click "Select..." and navigate to the MS Access document you created in Part 2. Select it.
Click ok, Click OK again. Then click Apply.

The only thing left to do is to point your software at the second ODBC connection you created in Part 3, or directly at the MS Access file in part 3, depending on your needs. NOTE: If you're using 64-bit software to retrieve the data, setup the ODBC in 64-bit mode instead (C:\Windows\SysWOW64\odbcad64.exe)