Linking Excel as a linked server

• Rushdi Basir

  SSChasing Mays

  Points: 653

  More actions

  December 2, 2004 at 9:19 am

  #163294

  I have linked a server for an Excel file which have multiple work books. I am trying to find which work books (tables) in the linked server. I looked for this info in Master sysobjects, but it's not there. Can someone please help me to find out this info?

  Thanks in advance,

  Rushdi

• Scott Thornburg

  Hall of Fame

  Points: 3347

  More actions

  December 3, 2004 at 12:52 am

  #532344

  Rushdi,

  Are you trying to list each worksheet in a single Excel workbook?  If so, once you have established a linked server to the workbook, execute:

  sp_tables_ex <Linked Server Name>

  This will list all worksheets in your workbook as individual tables.

   

  Scott Thornburg

  Volt Information Sciences