ODBC Administratoron 64Bit OS - Excel Issue

Say, having same issue on Windows 7 64 Bit machine & Server 2008 with Excel 2013 (32Bit Version) installed on both machines. odbcad32.exe file in Windows\system32 is 88.0 KB (90 112 bytes) File Version 6.1.7600.16385
Kindly assist
Excel.JPG
shaunwinginAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

QlemoBatchelor, Developer and EE Topic AdvisorCommented:
The screenshot certainly is not from ODBC Administrator from System32 folder but from SysWOW64, with that amount of drivers. But I could be wrong.
Anyway, 32bit drivers need to be defined in SysWOW64\odbcad32.exe, and 64bit ones in System32\odbcad32.exe. The ODBC Administrator you start via Start Menu is 64bit.
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
BTW, what is your issue? You didn't tell.
0
shaunwinginAuthor Commented:
The ODBC Manager would not let me configure Excel ODBC - suspect this is why getting the issue below:

See attached issue - I'm trying to link to excel file in Groupmail 6
Groupmail.JPG
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

shaunwinginAuthor Commented:
BTW getting same issue on Windows 7 32Bit installation
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
I cannot see where you called that config dialog in. Did you assign a Excel file directly in the DSN config?
I've just tried using both a DSN with XLS file pre-configured and without on W7 x64 with Excel 2010 x86, and were able to import data via the OLE DB => ODBC DSN bridge without issues and additional setup steps.
0
shaunwinginAuthor Commented:
I get this error if run file called System32\odbcad32.exe
and try configure the Excel DSN - its preconfigured.
A subsequent error is component not found in registry
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
I don't believe you get the same issue on W7 x86. Either it is an issue with 64bit and 32bit architecture mixed up, or the driver is corrupt. That hardly can be the same on two different, arbitrary systems. And the dialog does not at all look like the ODBC Administrator dialog.
0
shaunwinginAuthor Commented:
I've managed to connect to Excel with File DSN but only show 2003 file format - is there driver for 2013 xlsx format?
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
You might have to install 2007 Office System Driver: Data Connectivity Components, if you don't have a "Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)" listed.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
shaunwinginAuthor Commented:
With this installed. On Win64 OS C:\Windows\SysWOW64 odbcad32.exe allows Excell Driver to now work
Options are
Excel 12.0
Excel 2000

Does 12.0 support xlxs files?
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Yes, it should be the "Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)" as listed.
0
shaunwinginAuthor Commented:
tx
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.