Hi guys, I have a .csv file wich has the following information (exactly like this): List Name: User Format Version:220.127.116.11 Date:12/11/2012 12:00:34 Equipment.:L6867000214 IP:172.21.12.62 User,Name,Total,B&W ,[technical],76,76 ,[Daise],559,559 ,[Richard],0,0 I want to execute a create table and a bulk insert transaction but I don't know how to insert the information of the top lines of the .csv file like "Equipment.:L6867000214" and "IP:172.21.12.62". I need to create a collumn called "Equipment",other collumn called "IP" and insert this information (repeat "L6867000214" and "172.21.12.62" in all records bulk inserted). The result must be like this: IP,Equipment.,User,Name,Total,B&W, Color 172.21.12.62,L6867000214,,[technical],76,76 172.21.12.62,L6867000214,,[Daise],559,559 172.21.12.62,L6867000214,,[Richard],0,0 I have no idea how to do that. Could anyone here help me out on this issue? Thanks a lot!