Ran into the same issue here. This function causes my query to literally be 15 times slower. Going from under 1 second to over 15.

Haven't found a work around yet.

There are a couple pretty good applications out there that can convert most formats to the kindle. I even use mine to read comics (no color does suck but better...

opc.three rocks it again!

I have a kindle and I love it. As was said - battery life is literally weeks per charge. Very easy on the eyes as well. I use it just...

I've been battling the same thing. It happens to me on a fresh install on a Win 7 32 bit machine.

I can't find anything that works. You'd think it be...

Good stuff! Wish I had found this article a year ago. I struggled getting started before. I hope this helps people just getting their feet wet.

What do you think is the best way to handle that error then? I'm just writing this for my own personal growth so I don't have a security team to...

Nope. Have you ever used sp_validatelogins? It tells you what logins you have on your server aren't in your AD. I'm looking for the opposite.

I am not sure there...

Alright. Talk about monstrous journey into unknown territory.

I finally figured out the what was the matter. It had nothing to do with the spreadsheet. It had everything to do...

Dreaded Msg 7303!!!

OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error".

Msg 7303, Level 16, State 1, Line 1

Cannot initialize the data source object of OLE DB provider...

Sorry about that.

Here is what solved my problem:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\DevWork\ExcelTest\Example_SS.xls;Extended Properties="EXCEL 8.0;HDR=NO; IMEX=1"

""IMEX=1;" tells the driver to always read "intermixed" (numbers, dates, strings etc) data columns as text. Note that this...

FINALLY!!!

I got it.

Check this out

This worked perfectly.

I guess I need to read more about excel's extended properties.

Thanks for the reply. I was able to use the openrowset with Microsoft.Jet.OLEDB.4.0

SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',

'Data Source=C:\DevWork\example_ss.xls;Extended Properties=Excel 8.0')...[Sheet1$]

When I added your updates I got this:

OLE DB...

Here you go. It's not the same one I am using but I am getting the same results when importing this spreadsheet.

Thanks for the replies. I knew I was opening up a can of worms even mentioning IIS and SQL on the same machine.

I've stated my concerns to those in...