Inserting RAW Data to Table with selected columns

• fspalero

  SSC Enthusiast

  Points: 155

  More actions

  June 26, 2009 at 1:40 am

  #135748

  Hi,

  Anyone can help me, on how to insert a RAW Data to a Table with selected columns. I need only the Column1 and Column3 to be inserted. Thanking you.

  TextFile : RawData.CSV

  ----------------------

  Column1,Column2,Column3

  1111111,AAAAAA,BBBBBBB

  2222222,AAAAAA,BBBBBBB

  3333333,XXXXXX,CCCCCC

  Table : RAWDATA

  -----------------

  Column1 int,

  Column2 varchar(10),

  Column3 varchar(10),

  Regards,

  FPalero

• stopitallready

  SSC Eights!

  Points: 820

  More actions

  June 30, 2009 at 11:01 am

  #1017784

  You can bulk insert into a temporary table and then select the columns you desire. Here is an example:

  DECLARE @TempTable TABLE

  (

  Column1 INT,

  Column2 VARCHAR(10),

  Column2 VARCHAR(10)

  )

  BULK INSERT @TempTable FROM 'Filepath'

  SELECT Column1, Column2

  FROM @TempTable

  As an alternative, I believe that you can use a format file to bulk insert directly into your desired table.