ip address and openrowset

• Christopher Mark

  SSC-Addicted

  Points: 417

  More actions

  August 10, 2005 at 9:29 am

  #164847

  Could someone please help me with the openrowset syntax. I need to query an excel file using the ip address.Am i meant to put the address in the datasource?

  thanks

   

• MKulangara

  SSC Enthusiast

  Points: 142

  More actions

  August 10, 2005 at 10:01 am

  #581103

  See this thread...

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=207697

  I think replacing the @source with ip address should work.

  HTH