Read excel data from sql server 2008

• balu-1123884

  SSC Rookie

  Points: 34

  More actions

  November 2, 2011 at 12:57 am

  #251052

  Hi,

  i want to read excel data from sql server 2008.

  please do the needful.

  without installing excel on server machine.

  thanks in advance.

  Balu Reddy K

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  November 2, 2011 at 3:45 am

  #1402029

  use ssis to dump the data into a table or the import export data wizard, then you can query the table with the data

• November 2, 2011 at 4:52 am

  This was removed by the editor as SPAM

• Jamie Ashton

  Mr or Mrs. 500

  Points: 587

  More actions

  November 2, 2011 at 8:40 am

  #1402173

  You could also add it as a Linked Server.