<br /><font face="Times New Roman" size="2">Hi,</font><br /><br /><br /><font face="Times New Roman" size="2"> i try
toload data from flat file (comma delimiter format) into temporary table . i use COPY command as below:</font><br /><br
/><fontface="Times New Roman" size="2">dwnc=# copy biosadm.custdo_temp</font><font face="Times New Roman"> </font><font
face="TimesNew Roman" size="2"><br /> dwnc-# from '/home/bios/customer_data/CustomerDO_new.CSV'</font><font face="Times
NewRoman"> </font><font face="Times New Roman" size="2"><br /> dwnc-# WITH DELIMITER ',' ;</font><font face="Times New
Roman"><br/></font><font face="Times New Roman" size="2"><br /> ERROR: copy: line 141, Extra data after last expected
column</font><fontface="Times New Roman"> </font><br /><br /><br /><font face="Times New Roman" size="2">do u have any
ideawhat causes the above error ???or is there any command can be used to load data as requested. tq </font>