|
Home > Archive > MS SQL Server ODBC > November 2005 > Problem with DTS reading from spreadsheet
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Problem with DTS reading from spreadsheet
|
|
| Andy S. 2005-11-08, 8:23 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 2005-11-08, 8:23 pm |
| Are you seeing this?
Excel Inserts Null Values
(http://www.sqldts.com/default.aspx?254)
Allan
"Andy S." <andymcdba1@noreply.yahoo.com> wrote in message
news:#5c#mlL5FHA.472@TK2MSFTNGP15.phx.gbl:
> 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.
>
> ********************
********************
*********
| |
| Andy S. 2005-11-09, 9:23 am |
| 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.
"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:uEUNVTM5FHA.3496@TK2MSFTNGP10.phx.gbl...
> Are you seeing this?
>
> Excel Inserts Null Values
> (http://www.sqldts.com/default.aspx?254)
>
>
> Allan
>
> "Andy S." <andymcdba1@noreply.yahoo.com> wrote in message
> news:#5c#mlL5FHA.472@TK2MSFTNGP15.phx.gbl:
>
>
|
|
|
|
|