I'm exporting a table from SQL 2005 using the bcp commandline utility with a fmt file. The file now looks something like this:

Code:
9.0
20
1       SQLCHAR       0       4       ";"      1     EXPORT_ID          ""
2       SQLCHAR       0       4       ";"      2     BATCH_NR           ""
....
I have two questions:
- the EXPORT_ID and BATCH_NR are both INT datatypes, how does the 'Host file data length' (here 4, fourth column on the left) relate to that?
- Is there a way to surround the exported values with quotes, so the output becomes:

Code:
"1234";"555555";...
thanks