|04 Aug 2012||#1|
| || |
how to establish a ODBC connection in Windows 7 64 bit ?
I have created a ODBC connection between MS Acceess 2003 and Excel 2003 in Windows 7 32bit enviroment . The Macro ( code ) is as follows :
"ODBC;DSN=MS Access Database;DBQ=D:\Acces7dat\STOCKS.mdb;DefaultDir=D:\Acces7dat;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTim" _
), Array("eout=5;")), Destination:=Range("A1")) ... etc , transferring data from MS Access file stocks.mdb to an Excel spreadsheet for proccessing etc . All this works fine for the last three years until I have installed Windows 7 64 bit . Googling the problem found that I have to run the Windows/SysWOW64/obdcad32.exe file . Doing this appears the ODBC Data Source Admiinstrator with the tabs :
User DSN , System DSN , File DSN , Drivers , Tracing , Connection Pooling and About , and I can't configure all this in order to create a ODBC connection . First , is this the correct way to solve the problem and second how to setup the ODBC Data Source Admiinstrator under all these tabs ? Any help ? thanks in advance.
PS : I have reinstall Ms office 2003 in order to add missing items etc but no luck .
|My System Specs|
|Similar help and support threads for2: how to establish a ODBC connection in Windows 7 64 bit ?|
|Windows Media Center cannot establish a connection xbox???||Media Center|
|odbc connection win7 pro to unix||Network & Sharing|
|ODBC connection problem||Network & Sharing|
|Unable to establish Remote Desktop Connection Windows 7||Network & Sharing|
|Cannot establish remote desktop connection||Network & Sharing|
|Can't Establish LCD Monitor Connection via DVI||Hardware & Devices|
|Can't establish VPN connection||Network & Sharing|
|Our Sites ||Site Links ||About Us ||Find Us |
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd
All times are GMT -5. The time now is 05:17 AM.