-
1
- #1
erickparis
IS-IT--Management
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
(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