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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-27 : 08:02:20
|
| pradeep writes "I am using Bulk Insert to copy data from a CSV file to a SQL server 2000 table. The CSV file contains 7 fields and the target table contains 8 fields one of which is Computed columns. I would like to know whether it is possible to copy only selected columns" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-08-27 : 08:01:37
|
| Yes, you can use a bcp format file. Books Online has an example of doing exactly what you're looking for, under "bcp utility, format files". Once you create the format file you can specify it in the WITH (FORMATFILE='filename') clause. |
 |
|
|
|
|
|
Bulk Insert