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!