Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I am working on a Windows Server 2003 x64 bit OS. Under ODBC connections, I am seeing only "SQL Server" and "SQL native Client". I wanted to make a datasource for xls.

I have already performed the following things and there is no use ::

  1. Gone through the reply specified in JET and ODBC driver missing, can not get data from MDBs but there is no use for me. I think the link sol;ves the problem for a 32 bit OS.

  2. Installed Mdac 2.8

Any help on this would be greatly appreciated.

share|improve this question

migrated from stackoverflow.com Feb 17 '10 at 21:49

This question came from our site for professional and enthusiast programmers.

1  
There is no 64 bit JET ODBC driver. support.microsoft.com/kb/957570 –  ta.speot.is Feb 17 '10 at 21:53

2 Answers 2

Thanks for the reply. Just to keep you updated, I already have Excel installed on my system. Even after that I was not able to create Excel ODBC driver from Administrative Tasks menu in Control Panel.

I just found a way to create the same and though of updating the forum. I have gone thorugh 64 Bit ODBC. It says that, we will need to use the following command to achieve the ODBC connection for Excel files : %windir%\syswow64\odbcad32.exe.

share|improve this answer

You might check out the 2007 Office System Driver: Data Connectivity Components pack. It includes ODBC drivers for Access and Excel.

Or you might look at http://office.microsoft.com/en-us/excel/HP052009501033.aspx It explains that the excel 2003 drivers are installed when you install excel.

And, finally, check out this post about using the Excel ODBC driver in 64 bit windows.

share|improve this answer
    
As a last ditch step, just install Excel on the server. –  Chris Lively Feb 17 '10 at 14:40

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.