SQL Server Performance

Reading a CELL without using Name Range

Discussion in 'SQL Server DTS-Related Questions' started by dineshasanka, Aug 30, 2005.

  1. dineshasanka Moderator

    Is there any way of reading the contain of a given cell from DTS. I can't create a Name range as I don't have control over the Excel
  2. FrankKalis Moderator

    Don't know what it's like in DTS. Maybe you'll find something on www.sqldts.com
    But have a look at the Excel object model for Range (Enumeration (I believe it must be translated so, or Array()) in the online help. You don't need names.


    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
  3. dineshasanka Moderator

    I searched at sqldts but couldn't find any.
    I will look for Excel object model
  4. Madhivanan Moderator

  5. dineshasanka Moderator

Share This Page