Exporting single value to excel

• vsjayashri

  Right there with Babe

  Points: 797

  More actions

  October 21, 2008 at 3:21 am

  #214270

  Hi

  declare @dFrom varchar(12)

  set @dFrom = convert(varchar,getdate(),112)

  INSERT INTO OPENROWSET ('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=D:\test.xls','SELECT * FROM October$B2:B2]')

  @dFrom

  I want to write the date on the october sheet in b2 cell,

  I tried the above method but failed to do,

  Please help .

  Jayasri

• Madhivanan-208264

  SSCertifiable

  Points: 7516

  More actions

  October 21, 2008 at 5:09 am

  #887514

  vsjayashri (10/21/2008)

  ---

  Hi

  declare @dFrom varchar(12)

  set @dFrom = convert(varchar,getdate(),112)

  INSERT INTO OPENROWSET ('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=D:\test.xls','SELECT * FROM October$B2:B2]')

  @dFrom

  I want to write the date on the october sheet in b2 cell,

  I tried the above method but failed to do,

  Please help .

  Jayasri

  INSERT INTO OPENROWSET ('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=D:\test.xls','SELECT * FROM October$B2:B2]')

  SELECT @dFrom

  ---

  Madhivanan

  Failing to plan is Planning to fail