Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mitasid
Yak Posting Veteran
51 Posts |
 Posted - 2006-08-01 : 17:57:53
|
| Hi guysI am using the Bulk insert command to import a flat file to the SQL server 2005.My flat file contains about 1 million rows.I have already created an empty table to insert the rows from the flat file.But I dont want to import the first row into my table in the database.Is there a way I can give some some sort of condition in my bulk insert command so that the first row from the flat file does not get imported??Here is my bulk insert statement:BULK INSERT new1 FROM 'f:\My Documents\flatFileBaseline\one.txt' WITH (FIELDTERMINATOR = ',')CheersMita |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-08-01 : 18:04:32
|
| Check out BOL for the BULK INSERT statement. You can specify FIRSTROW HTH,Tim |
 |
|
|
|
|
|
Bulk insert problem