December 16th, 2012, 02:54 PM
Join Date: Dec 2012
Time spent in forums: 4 m 3 sec
Reputation Power: 0
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 ideia how to do that. Could anyone here help me out on this issue?
Thanks a lot!