Excel using ODBC instead of OLE-DB (not possible)

Question

Excel using ODBC instead of OLE-DB (not possible)

Markus Hofelich 21

Hello,

Unfortunately it is no longer possible to add an ODBC query in Office365. Excel always makes it an OLE DB query and then shows the following query properties:

e2c10fce-aca8-4f6d-bff6-e9b27d07014e

If I now create the file in Office2013, then "database query" is displayed for connection type:

e61ef86d-64d9-4047-a215-5c491bb4af42

Because Office365 uses OLE DB, I can no longer retrieve the data in Office2013.

Best regards
Markus

Markus Hofelich 21 Reputation points

2021-08-02T07:18:57.477+00:00

@mod can you please change the order of the pictures? I accidently did it in the wrong order. Thanks
Sam of Simple Samples 5,546 Reputation points

2021-08-02T17:40:01.593+00:00

Is the real issue that you cannot retrieve Office 2013 data? ODBC and OLE DB are interfaces to the data. There is no difference in the format stored on the drive.
Markus Hofelich 21 Reputation points

2021-08-04T07:30:40.653+00:00

The issue is that you cannot recieve Data from ODBC if you create the file in O365 and then open it in O2013. The issue is that O365 is using OLE-DB and O2013 is using O2013, so that might be the reasion that its not working.
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2021-08-05T09:28:07.907+00:00

Did you check if it is 32-bit or 64-bit problem? Make sure 2 applications using the same bit version.
Markus Hofelich 21 Reputation points

2021-08-06T09:04:49.207+00:00

Yes, its both 32bit

Accepted answer

0 additional answers

Your answer

Markus Hofelich 21 Reputation points

2021-08-02T07:18:57.477+00:00

@mod can you please change the order of the pictures? I accidently did it in the wrong order. Thanks
Sam of Simple Samples 5,546 Reputation points

2021-08-02T17:40:01.593+00:00

Is the real issue that you cannot retrieve Office 2013 data? ODBC and OLE DB are interfaces to the data. There is no difference in the format stored on the drive.
Markus Hofelich 21 Reputation points

2021-08-04T07:30:40.653+00:00

The issue is that you cannot recieve Data from ODBC if you create the file in O365 and then open it in O2013. The issue is that O365 is using OLE-DB and O2013 is using O2013, so that might be the reasion that its not working.
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2021-08-05T09:28:07.907+00:00

Did you check if it is 32-bit or 64-bit problem? Make sure 2 applications using the same bit version.
Markus Hofelich 21 Reputation points

2021-08-06T09:04:49.207+00:00

Yes, its both 32bit

Answer 1

Emi Zhang-MSFT 30,046 Microsoft External Staff

Hi @Markus Hofelich ,
How did you create the connection, did you go to Data group and get data from one of the connection methods as shown in the following picture?

Did you use the same data source?

In Office 365, the default connection in Data group is PowerQuery, I suggest you go to Data- Get Data- Legacy Wizards from list:

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

If the response 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.

Markus Hofelich 21 Reputation points

2021-08-04T07:34:34.977+00:00

i created it using "ODBC" or "empty query"

]1

Both are not working in O2013
Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2021-08-17T01:50:54.5+00:00

Your picture is display you're using Power Query connection in Excel, try going to File- Options- Data- check all options as shown in the following picture:

Then you can get the following legacy data import wizards, this may help you enable the data connection both Office 2013 and 365:
Markus Hofelich 21 Reputation points

2021-08-18T12:58:26.93+00:00

Thx, this solved my problem!

Share via

Excel using ODBC instead of OLE-DB (not possible)

0 additional answers

Your answer