To Connect Excel Sheet through Linked server

• sqlfriends@sql.com

  SSCommitted

  Points: 1504

  More actions

  February 4, 2010 at 12:47 am

  #215232

  :-)Dear All;

  How to connect the Excel sheet through the Sql Qry;

  I have a some Bulk information in Excel Sheet to Fetch the Data through the SqlQry;

  any one to Help this ;

  Thanks;

  Faijurrahuman

  MCA

  Coimbatore

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  February 4, 2010 at 3:25 am

  #1113587

  Have you ever used the OPENROWSET FUnction?

  Please refer to the Link below concering syntax and usage:

  http://www.sql-server-helper.com/tips/read-import-excel-file-p01.aspx

  You can also deine a Linked Server if a peranent connection is needed:

  http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=135

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/