Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

BCP IN with flat file 1

Status
Not open for further replies.

erickparis

IS-IT--Management
Jun 22, 2004
1
FR
Hi,
(Sorry, I come from the Oracle world)
I have a very tricky job to do, but I can't achieve it.
I'd like to upload a flat file without field separator.

Nota : my table is granted all to public. My data file is RW for everybody.

My flat file is (fixed lengh):
Name 5 car
birthday 8 car
currency 3car
job 10 car
Example :
james19650506USDIT MANAGER
tom19600908JPY DEVELOPER
...
I'd like to know what is the right command to upload this kind of file
I have tried :
bcp tablename in filename.dat -Uusername -Ppassword -c
bcp tablename in filename.dat -Uusername -Ppassword -n
bcp tablename in filename.dat -Uusername -Ppassword
But neither succeed.

Thanks in advance for your help

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top