This looks like you do not have a sheet called “Markets” in the workbook Markets. You can’t post IFCode. There is also Office System Driver Beta: Hmm, That still doesn’t seem to work. The Microsoft Office team has just released a bit driver. You can’t post new polls. The currently last post at this link:

Uploader: JoJogis
Date Added: 12 June 2004
File Size: 58.45 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 48288
Price: Free* [*Free Regsitration Required]

Your Select statement works fine for me. What piece am I missing? Sign up or log in Sign up using Google. You can’t edit your own posts. Install the bit Oracle driver and enable 32 bit applications? IF the application pool is set to Enable 32 bit applications the code works as expected; however the oracle driver I am using fails as it is only 64 bit. Does the file contain a sheet called “Markets”.

You can read topics. Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.


Unthreaded, ascending Unthreaded, descending. I am using the following code to access the excel file: Data source name not found and msdzsql default driver specified Any suggestions?

ADO Connection Strings Examples

Code below, with error afterwards: You can’t post JavaScript. You can’t post IFCode. Does the file exist in C: I had posted these sheet names earlier, so thought you were indicating the filename again. You can’t delete your own events. If you have a 32bit version of Office installed, it will give you an error message when you try to install it.

Import data from Excel (xlsx) to SQL Server bit

You can’t post new polls. Our server is running Windows in 64 bit mode.

I tried it with the other sheet names: You can’t delete your own topics. You can’t post new topics.

I guess I should clarify, this is SQl Serverif that makes any difference down the road mddasql anyone else. Or is there some little typo keeping it from finding the file? That could be it then, I thought it was dependent on the filename.


You can’t delete your own posts.

You can’t edit other posts. You can post emoticons. The currently last post at this link: Make sure that it does not include invalid characters or punctuation and that it is not too long. Sign up using Facebook.

64bit – Excel ODBC and 64 bit server – Stack Overflow

Email Required, but never shown. Post as a guest Name. The Microsoft Office team has just released a bit driver. You can’t edit your own topics.