Linked server - excel

• ahn

  Valued Member

  Points: 51

  More actions

  December 21, 2010 at 12:53 am

  #244501

  Hi,

  We have an excel file that we want to create a temp table of.

  In my test environment I solved this by creating a Linked Server named Excel_ahn.

  SELECT * INTO #temp_picture FROM EXCEL_AHN...Ark1$

  select * from #temp_picture

  In production mode, I do not have access to create a Linked Server. Is it another way to read data from an excel sheet?

  Thanks.

  Regards

  Anne

• December 21, 2010 at 3:56 am

  This was removed by the editor as SPAM

• roi.reuven

  SSCommitted

  Points: 1700

  More actions

  December 23, 2010 at 12:35 am

  #1265797

  you can use ssis for moving the data and query