bulk insert from a Excel Sheet

• Mouli

  Right there with Babe

  Points: 735

  More actions

  April 8, 2003 at 8:00 am

  #159293

  I need to import data from a Excel Sheet into a table using the bulk insert command.

  Can I get know the command.

  I tried the below syntax

  BULK INSERT CONFIG_25.dbo.[HISConfigValues_RD]

  FROM 'D:\HISConfigValues_RD.XLS'

  WITH (ROWTERMINATOR = '' )

  I get the below error

  OLE DB provider 'STREAM' reported an error. The provider did not give any information about the error.

  The statement has been terminated.

  Thanks in advance

  Mouli

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  April 8, 2003 at 9:22 am

  #453459

  you should import from excel to a .txt and then bulk insert from the .txt adding the datafiletype parameter.