Share via

creating ODBC connection for Microsoft Excel Driver 64 bit

Rusty1208 0 Reputation points
2024-10-23T07:42:51.4066667+00:00

I have ran ODBC 64-bit as administrator. I have added a new connection with the SystemDSN tab. I then click on Microsoft Excel Driver. In the Dialog I enter the datasource name, description and click on select Workbook and choose my Office 365 Excel 64 bit file. I select version Excel 12.0 from the dropdown. I click ok and the dialog disappears with no errors but the new connection does not appear in the System DSN list. Can anyone advise what I am missing please? Why is it not showing int he dsn list?

Thanks

Rakhee

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,725 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 25,546 Reputation points Microsoft Vendor
    2024-10-24T01:28:23.9766667+00:00

    Hi,

    I suggest you check if there is Excel 16.0 in list, the Excel 365 is 16.0 version not the 12.0 version.

    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.

  2. Rusty1208 0 Reputation points
    2024-10-24T13:21:56.75+00:00

    resolved it by installing AccessDatabaseEngine64 again. This resolved my issue

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.