This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 86%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello,
I am trying to load data from an Azure Cosmos DB into an Excel 2019 spreadsheet. I started by using a data source created with the 64-bit version of the Microsoft Azure Document DB ODBC Driver and was getting errors (architecture mismatch) until I realized that Office 2019 had installed 32 bit versions of the programs. Assuming that I would need to use a 32-bit driver I installed the 32-bit version of the Microsoft Azure Document DB ODBC Driver. However, using the 32-bit ODBC Data Source Administrator when I try to add a new data source and select the Microsoft Azure Document DB ODBC Driver I get an error message (system error 126, DocumentDBODBC_sb32.dll not found). See attached image.
That DLL is present on my PC, however it is located in the "Program Files (x86)" folder, not "Program Files" folder where the ODBC admin seems to be looking for it.
Can anyone suggest what I might be doing wrong, and how I can add my data source to the driver?
Thank you.
I would suggest you to follow the answer of MarkBrownMSFT.
Any questions, you could post back.
Regards,
Erin
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Ok, I found my problem. I had mistakenly installed the 32-bit ODBC driver for a 32-bit platform. What I should have used was the 32-bit driver for a 64-bit platform.
https://video2.skills-academy.com/en-us/azure/cosmos-db/odbc-driver
Everything now works as it should.
ODBC is not a supported means of importing data between Excel and Cosmos DB. It is much preferred to use Azure Data Factor with the Excel and Cosmos DB connectors.
More information on the Cosmos DB connector can be found here. https://video2.skills-academy.com/en-us/azure/data-factory/connector-azure-cosmos-db
More information on the Excel connector is here. https://video2.skills-academy.com/en-us/azure/data-factory/format-excel
Thanks.
Thank you for your response. Unfortunately I inherited this problem and I need to find a way to work with it in its current form. While it may not be the preferred method, using the 64-bit ODBC driver with a 64-bit version of Excel does work. I would be happy to use that arrangement except that I don't have a 64-bit version of Excel available.
Also, I looked at the links you provided and it appears that Azure Data Factory can only use Excel documents as a data source.
My application simply requires using VBA scripts in an Excel spreadsheet to load data from a remote Cosmos DB source into a worksheet for further processing.
I suspect that I could get this working if only I could get past the problem of getting the data source set up in the 32-bit ODBC driver.
Ok understood. You can download the 32 and 64 bit ODBC driver from here.
https://video2.skills-academy.com/en-us/azure/cosmos-db/odbc-driver
Thanks.