How can we extract data from excel file in stored procedures

• dhamodharankms

  SSC Enthusiast

  Points: 145

  More actions

  January 7, 2011 at 12:49 am

  #388575

  Hi,

  I want to extract data from excel file and insert into table from my stored procedure.

  Path will be passed as input parameter to stored procedure.

  I have to extarct data from the file.

  Please help me. i don't want to use SSIS package or Import/export wizard.

• LutzM

  SSC Guru

  Points: 107049

  More actions

  January 7, 2011 at 1:13 am

  #1270476

  http://support.microsoft.com/kb/306397/EN-US/

  Edit: powered by SSC, the Google alternative 😉

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

• Iulian -207023

  SSCertifiable

  Points: 7639

  More actions

  January 7, 2011 at 2:22 am

  #1270498

  Hi,

  You can try this query:

  SELECT * FROM

  openrowset(

  'Microsoft.Jet.OLEDB.4.0'

  , 'Excel 8.0;database=PATH\FILE_NAME'

  , [SheetName$]

  );

  there are also other posts on this regard: http://www.sqlservercentral.com/Forums/Topic684266-149-1.aspx

  Regards,

  Iulian

• dhamodharankms

  SSC Enthusiast

  Points: 145

  More actions

  January 7, 2011 at 3:12 am

  #1270526

  Thank you