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 |
|
dgaylor
Yak Posting Veteran
54 Posts |
 Posted - 2003-04-10 : 18:18:45
|
| Is it possible to bcp a whole table out of sql server into a fixed text file format without using a format file? Thanks. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-04-10 : 21:36:20
|
| No, I don't think so, but bcp will generate a format file for you, and they're not hard to put together at all. You can copy an example out of Books Online and modify it by hand. You might even be able to use the INFORMATION_SCHEMA.COLUMNS view to generate a format file from the column data. |
 |
|
|
|
|
|
BCP Export