Joined: 16 Dec 2012
|Posted: Sun Dec 16, 2012 9:23 pm Post subject: Create Table + Bulk Insert
I have a .csv file wich has the following information (exactly like this):
List Name: User
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:
I have no idea how to do that. Could anyone here help me out on this issue?
Thanks a lot!