Updated documentation can now be found via our YF community HERE
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?
solution found on this website: http://stackoverflow.com/questions/6721702/windows-7-64-bit-odbc-drivers-for-ms-access-missing
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
and make your connection. the driver for MS Access will work fine now.
thank u so much sir
DANKE SCHON MON AMI
Thk u a loooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooottttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttt
If, like me, none of this made any difference, go to here
http://www.microsoft.com/en-us/download/confirmation.aspx?id=13255I'd just been "upgraded" to office 365, and the Access ODBC drivers were just not to be found. - I ran this download, and in conjunction with using the right version of the admin program (in SysWOW64), I could actually get some work done