Re: dbload

Alex McLintock (Alex@arcfan.demon.co.uk) wrote: : Help! : I am trying to dbload a table with 78 fields. (The table does have : 78 fields, my ascii text has 78 fields, the dbload commands say 78) : but I am getting the error : : Number of values given does not match number of columns Make sure that: 1) Each line has exactly 78 delimiters, and each delimiter *follows* the data field; 2) The delimiter character does not occur anywhere else in the data, unless escaped with a backslash '\\'; 3) The data never has a backslash at the end of a data field, which would escape the delimiter; and 4) The insert column list ["INSERT INTO tab1 (col1, col2, ...)"] (if you are using one) has the correct number of columns. That's all my ideas. Does it successfully load *any* of the rows? If you still have trouble, E-mail me your command file, schema and sample data and I'll take a look. : -- : Alex McLintock [also alexmc@biccdc.co.uk] : Editor for the Project Galactic Guide (alt.galactic-guide) Number 6 -- Jeff Sturm jsturm@garnet.msen.com