How to Import data from Excel to Table and Export data table to excel

• chandrasekaran.ganapathy

  SSCommitted

  Points: 1738

  More actions

  April 6, 2010 at 3:28 am

  #1146367

  The same error which earlier i described is coming.....

  Big hectic for me...

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  April 6, 2010 at 4:02 am

  #1146376

  chandrasekaran.ganapathy (4/6/2010)

  ---

  SELECT * INTO XLImport4 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

  'Excel 8.0;Database=C:\test\xltest.xls', [Customers$])

  Hi Here Customers$ refers the table name?

  try with OPENDATASOURCE

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

• chandrasekaran.ganapathy

  SSCommitted

  Points: 1738

  More actions

  April 6, 2010 at 10:13 pm

  #1146995

  Insert into Table1

  SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',

  'Data Source=C:\test\testing.xls;Extended Properties=Excel 8.0')...[sheet1$]

  finally this code is working..

  Thanks bhuvanesh......