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
    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