imani_technology (4/19/2011)
I'm using SQL Server 2008 R2 and Excel 2007. I hope this helps.
So, if I'm not mistaken, you are using a .xlsx file, right?
If yes, you should use the ACE provider, not the JET provider. (In your original question you said you were using .xls files.)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP