Retrieving data from excel file

• Smruti-255597

  Old Hand

  Points: 301

  More actions

  September 14, 2005 at 6:30 am

  #87637

  Hi

  I have 100 records in a excel file.

  I want a query to select these records.

  So in sql server is it possible

  If y Please help me.

  Than'x

• David Burrows

  SSC Guru

  Points: 65144

  More actions

  September 14, 2005 at 7:20 am

  #589695

  SELECT * FROM

  OPENROWSET('Microsoft.Jet.OLEDB.4.0',

  'Excel 8.0;Database=C:\temp\book1.xls;HDR=YES', [sheet1$])

  Change to the path for the xls file and use HDR=NO if there are no headers in the file (in which case the columns will be named F1,F2... etc)

  Far away is close at hand in the images of elsewhere.
  Anon.