Groups | Blog | Home
all groups > sql server odbc > november 2005 >

sql server odbc : Problem with DTS reading from spreadsheet



Andy S.
11/8/2005 6:08:57 PM
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.
andymcdba1@noreply.yahoo.com

Please remove "noreply" before replying.

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

Allan Mitchell
11/9/2005 12:30:47 AM
Are you seeing this?

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


Allan

[quoted text, click to view]
AddThis Social Bookmark Button