Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I would really appreciate some help with this. Running

  1. Windows 2008 R2 EE x64 SP1 with latest updates
  2. Office 2010 X64 (verified) with latest updates

When I create a System DSN with an Excel spreadsheet as the source and click on the "Select Workbook" button, the ODBC Data Source Administrator Window crashes/closes automatically. I tried to do this from the command line, using the following syntax:

odbcconf configdsn "Microsoft Excel Driver (*.xls)" "DriverId=790|Dbq=C:\temp\DSCOLUMNS.xls|DefaultDir=C:\temp|DSN=DSCOLUMNS|description=yada yada"

and it gives me the following error message

CONFIGDSN Unable to create a datasource for the "Microsoft Excel driver (*.xls)' driver. Component not found in the registry with the error code -2147467259.

seems like this is an architecture mismatch error. but why? I am running x64 everything. please help!

share|improve this question

2 Answers 2

I wonder if you are using the right configuation extension - excel 201o .xlsx instead of .xls? or are you using an excel workbook saved in compatibility mode?

share|improve this answer

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.