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:
|Date Added:||12 June 2004|
|File Size:||58.45 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|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”.
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
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.