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 |
|
venablc
Starting Member
2 Posts |
 Posted - 2009-08-07 : 07:40:41
|
| Hi,I have a formatted text file which i need to get into a table in the quickest possible way. I have used BCP in the past and it is very impressive! however in this paticular instance i need to get the data into a table which also has an identity column. Is there anyway to do this?Regards,Chris V |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-08-07 : 08:14:41
|
Yes.Create a format file.Or create a view without the identity column and insert into the view.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-10 : 08:01:57
|
| Use the -E option in bcp (case-sensitive) to import values into an identity column.Have a look in BOL |
|
|
|
|
|
|
BCP into table with identity column