Problem with DTS reading from spreadsheet

[Andy S.]

Has anyone encountered an issue with blank cells when DTS tries to read
a range from a spreadsheet using a SELECT * FROM [Sheetname$] query? I have
a spreadsheet where I read a range, and some of the cells show up as blank
even though there are values in them. If I alter the cell and resave the
sheet, it works fine. I suppose this could be worksheet corruption, but I
wanted to see if there were any other ideas about what to do. Thanks.


--

*************************************************
Andy S.
(e-mail address removed)

Please remove "noreply" before replying.

*************************************************

 

[Allan Mitchell]

Are you seeing this?

Excel Inserts Null Values
(http://www.sqldts.com/default.aspx?254)


Allan

 

[aaron.kempf]

no IT JUST DOESNT FUCKING WORK.

THATS ONE OF THE REASONS I FUCKING HATE EXCEL SO MUCH
SHIT DOESNT WORK LIKE IT SAYS IT SHOULD

just the basics; microsoft

start fucking fixing bugs you piece of shit company

oh.. is $70bn of OUR hard-earned money not enough to fix a half dozen
bugs?

MS is too fat and lazy to succeed; plz boycott MS everywhere
they just dont fucking get it anymore

 

[Andy S.]

Yes, thank you! It is amazing. This was driving me nuts. Excel will read
in the character data, the character mixed with number data, and ignore the
number data.

Your website is one of the best SQL sites out there. The looping example
alone was a lifesaver.

Are you seeing this?

Excel Inserts Null Values
(http://www.sqldts.com/default.aspx?254)


Allan

Has anyone encountered an issue with blank cells when DTS tries to read
a range from a spreadsheet using a SELECT * FROM [Sheetname$] query? I
have
a spreadsheet where I read a range, and some of the cells show up as
blank
even though there are values in them. If I alter the cell and resave
the
sheet, it works fine. I suppose this could be worksheet corruption, but
I
wanted to see if there were any other ideas about what to do. Thanks.


--

*************************************************
Andy S.
(e-mail address removed)

Please remove "noreply" before replying.

*************************************************