SELECT
  Campi
INTO TabellaSQLServer
FROM 
  OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=prova.xls;HDR=YES','SELECT * FROM [Foglio1$]')