Share via

Installation of driver for ODBC 64 bit to run Excel VBA .

Anonymous
2022-07-13T08:29:26+00:00

Hi,

I am not able to run Excel VBA sheets. When I checked my drivers I found that these drivers are missing from my system.

1.Microsoft Access drive

2.Microsoft Access Test Driver

3.Microsoft Excel Drive

4.Oracle in 12.2.20

I have a 64bit system and these drivers are missing from 64 bit ODBC data source 64 bit. Can you please help me to install these drivers as I cannot find these drivers anywhere.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-07-13T14:19:14+00:00

    Oh, I see.

    Then you have to install the latest version of Microsoft Access Database Engine (Redistributable) to retrieve data via the Access ODBC drivers.

    Please, use this link:
    https://www.microsoft.com/en-us/download/details.aspx?id=54920

    Best regards,
    Albert

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-07-13T11:45:20+00:00

    It is not working. When i go to the below step

    "Select 'Add' and scroll through to where you see the Microsoft Access Driver option. Click on it and select 'Finish'. A popup window will appear."

    When i click add a window pops up saying

    "select a driver for which you want to setup a data source" there only SOL server is present and nothing else.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2022-07-13T10:50:05+00:00

    Alright, thanks.

    • Navigate to your PC's Control panel > Administrative Tools > Data Sources (ODBC).

    • Select 'Add' and scroll through to where you see the Microsoft Access Driver option. Click on it and select 'Finish'. A popup window will appear.

    • Fill in the Data Source Name field with "MS Access" and hit OK

    • You'll be brought back to the ODBC Administrator window where you'll observe a message at the bottom saying you've successfully installed the Microsoft Access Driver(s).

    • Hit Ok.

    Hope this helps!

    Best regards,
    Albert

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-07-13T10:34:42+00:00

    I am using Windows 10.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2022-07-13T09:07:55+00:00

    Hello there,

    Thanks for reaching out here regarding this query. I'll be glad to help!

    Are you running a Windows or Mac OS?

    Warm regards,
    Albert

    Was this answer helpful?

    0 comments