3,919 questions
You have to create a ODBC DNS entry first. Important, the 32/64 bitness of the DNS entry must match your MS Excel bitness.
Regarding connection string see https://www.connectionstrings.com/ibm-db2/
No possibility to connect to IBM DB2 database
![](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(0, 82%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELW%3C/text%3E%3C/svg%3E)
Lukas Wagner
20
Reputation points
In earlier versions of Excel I had the possibility to connect directly to an IBM DB2 database.
Currently this possibility is missing. Can I activate it somehow?
The current version is Microsoft 365 MSO (Version 2402 ) 64 Bit
Microsoft 365 and Office | Excel | For business | Windows
Accepted answer
-
Olaf Helper 47,441 Reputation points2024-04-02T11:57:49.6166667+00:00 -
Lukas Wagner 20 Reputation points
2024-04-02T13:06:42.35+00:00 Thanks for the help.
I created a "ODBC data source" in windows and then I connect with the data assistent (legacy)
Sign in to comment -
1 additional answer
Sort by: Most helpful
-
Olaf Helper 47,441 Reputation points
2024-03-29T11:23:11.9033333+00:00 Yes, there have been a "Aus IBM DB2 Datenbank", but at the end it was just a preselection of the data provider to use, nothing else; no magic trick behind.
Use "Aus anderen Quellen", then a data provider of your choose, e.g. OleDB or ODBC and follow the wizard.
-
![](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(147.20000000000002, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jiajing Hua 18,065 Reputation points Moderator2024-04-01T08:03:35.64+00:00 Hi @Lukas Wagner
Please check Olaf Helper's reply. Any further issues, welcome to post back.
-
Lukas Wagner 20 Reputation points
2024-04-02T11:42:11.0933333+00:00 When I click on "aus ODBC" a window opens, but the Verbindungszeichenfolg is not specified. What I have to write there?
Sign in to comment -