Reading data from excel sheet using SQL

• subramani.rudrappa 78855

  SSC Eights!

  Points: 848

  More actions

  November 16, 2012 at 6:24 am

  #285101

  Hi,

  could any one shed some light to read data from Excel sheet using SQL code.

  Requirements

  1)Excel sheet will be placed in some server path

  2)Read the data available in particular column and from particular excel sheet.(say sheet 1 or sheet2 etc)

  3)do we have any challenges while reading data from excel 2007 or 2010

• Tee Time

  Hall of Fame

  Points: 3745

  More actions

  November 16, 2012 at 6:50 am

  #1559786

  Take a look at this and see if it helps.

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82508

  I have not personally done this, as I lean toward importing the data into a SQL table, but I realise you may not have that option. 🙂