Specify columns to import using BULK INSERT

• Harry Douglass

  SSC-Addicted

  Points: 416

  More actions

  December 16, 2004 at 1:57 pm

  #59755

  I have a BULK INSERT sql file that executes serveral stored procedures.  The file is a CSV and all I need are three columns out of 15 that are inside this file. 

  How do I specify the three columns in the CSV file using the BULK INSERT t-sql? 

  Here is one of my scripts:

  CREATE PROCEDURE ComputedAttributesLoad

  (

    @FilePathName varchar(100)

  )

  AS

  TRUNCATE TABLE ComputedAttributes

  DECLARE @sql varchar(1000)

  BEGIN

    SET @sql = "BULK INSERT ComputedAttributes FROM '" +@FilePathName+ "' WITH (FIELDTERMINATOR = ',')"

  END

  EXEC(@SQL)

  GO

   

  Thanks in advance,

  Harry

• noeld

  SSC Guru

  Points: 96590

  More actions

  December 16, 2004 at 2:27 pm

  #534239

  Use the FORMATFILE to specify what you want from it

  HTH

   

  
  * Noel

• Harry Douglass

  SSC-Addicted

  Points: 416

  More actions

  December 17, 2004 at 12:54 pm

  #534364

  Thanks, HTH.  I will look up the usage online and give it a try.