How do I setup the DSN for Microsoft access ODBC driver?

Yellowfin FAQ shared this question 2 years ago
Answered

How do I setup the DSN for Microsoft access ODBC driver?

I am setting up the DSN to connect to my data sources, and I don?t have the drivers for Excel or Access. My list only includes SQL and SQL Express, do you know where I can download them?

de4cbf5951a1e218e1aa7a11e78cbf36

Comments (1)

photo
1

It’s likely the shortcut for setting ODBC data sources is pointing to the 32bit data sources instead of 64bit.

Go to control panel -> administrative tools –> select data sources(ODBC) –> then right click on that file –> go to properties –> in the shortcut tab -> change the path from %windir%System32odbcad32.exe to

%windir%SysWOW64odbcad32.exe

and make your connection. the driver for MS Access will work fine now.


However, if you still don't have the Access driver, then most probably you will have to install it. You need to download the Microsoft Access Database Engine 2016 Redistributable from the Microsoft download center. A 32bit driver and 64bit driver are both available.