Hi ,
How can I load a comma delimited file inot table.
I tried
Load data 'h:\test.txt' separeted by comma
INTO table A
got error about "separeted by comma"
Thanks in advance.
Pl. help ASAP
Printable View
Hi ,
How can I load a comma delimited file inot table.
I tried
Load data 'h:\test.txt' separeted by comma
INTO table A
got error about "separeted by comma"
Thanks in advance.
Pl. help ASAP
I THINK
I NEED TO WRITE LIKE THAT
Load data 'h:\test.txt'
INTO table A
FIELD TERMINATED BY ','
I WILL TEST WITH THAT.
HOPE THIS IS RIGHT?
Yes it is. Check the bad file after you execute.
THANKS, DID WORK