Create Table + Bulk Insert

The simplest way to populate your database with test data.

Create Table + Bulk Insert

Postby andreandre » Sun Dec 16, 2012 9:23 pm

Hi guys,

I have a .csv file wich has the following information (exactly like this):

List Name: User
Format Version:
Date:12/11/2012 12:00:34


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:". I need to create a collumn called "Equipment", other collumn called "IP" and insert this information (repeat L6867000214" and "" in all records bulk inserted). The result must be like this:

IP,Equipment.,User,Name,Total,B&W, Color,L6867000214,[1600],[technical],76,76,L6867000214,[6611],[Daise],559,559,L6867000214,[900301],[Richard],0,0

I have no idea how to do that. Could anyone here help me out on this issue?

Thanks a lot!
Posts: 1
Joined: Sun Dec 16, 2012 9:19 pm

Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests