
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). | |