InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 13:59:45 GMT20http://www.sqlservercentral.com/Forums/Topic742430-9-1.aspxYou can bulk insert into a temporary table and then select the columns you desire. Here is an example:[code]DECLARE @TempTable TABLE( Column1 INT, Column2 VARCHAR(10), Column2 VARCHAR(10))BULK INSERT @TempTable FROM 'Filepath'SELECT Column1, Column2FROM @TempTable[/code]As an alternative, I believe that you can use a format file to bulk insert directly into your desired table.Tue, 30 Jun 2009 11:01:16 GMTstopitallreadyhttp://www.sqlservercentral.com/Forums/Topic742430-9-1.aspxHi,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,Column31111111,AAAAAA,BBBBBBB2222222,AAAAAA,BBBBBBB3333333,XXXXXX,CCCCCCTable : RAWDATA-----------------Column1 int,Column2 varchar(10),Column3 varchar(10),Regards,FPaleroFri, 26 Jun 2009 01:40:54 GMTfspalero