MSSQL bcp command help

[benchpolo]

I have a download .txt fixed length file that I need to bulk import to my SQL table called bow_received. Can someone assist me with a start up sql code. This is the first time im using bcp for bulk import.

331008860000115 913600000057000 000000724080057 6040 P
331008860000115 927300000399720 000000728080071 3795 P
331008860000200 862900004780390 000000730082002 7640 P
331008860001008 505700000031320 301080710080052 1980 R
331008860001008 930400000028210 313080707080057 0165 R

Thanks.

[ck9663]

You're going to need a format file, for easy handling.

Start from here

-- CK