Réduire
Brouillon
0
08/03/2013
0
How do I create a format file for bcp ?
Mots-clés:
Sybase SQL
A quick trick for creating format files is to bcp out your table without specifying ascii mode (-c) or a format file (-f).  Then, bcp will prompt you for all the fields in the table and will create a format file for you (defaulting to bcp.fmt).  Then, you can quickly Ctrl-C the process and use the format file for other purposes (including bcping out in ascii mode).