Connecting Tech Pros Worldwide Forums | Help | Site Map

MSSQL bcp command help

benchpolo's Avatar
Member
 
Join Date: Sep 2007
Location: Nevada
Posts: 92
#1: Aug 4 '08
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.

3310088600001159136000000570000000007240800576040 P
3310088600001159273000003997200000007280800713795 P
3310088600002008629000047803900000007300820027640 P
3310088600010085057000000313203010807100800521980 R
3310088600010089304000000282103130807070800570165 R

Thanks.

ck9663's Avatar
Expert
 
Join Date: Jun 2007
Posts: 1,925
#2: Aug 4 '08

re: MSSQL bcp command help


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

Start from here

-- CK
Reply