RE: loading from file into table
} Vitaly E. Kursitis wrote
} There is a file "fff" that consists of
} K,H,28,3,
} K,H,28,4,
} K,H,28,5,
} K,H,28,6
}
} And there is a table fff, having the structure:
}
} Column Name Type Length Index Nulls
}
} diap Char 1 Dups No
} koef Char 1 No
} space Smallint Yes
} quality Smallint Yes
}
} When i run script "load from "fff" Delimiter "," insert into fff" using
} dbaccess i got the next message:
} 4 Numbers loaded
} and then ;
> 846: Number of values in load file is not equal to number of columns.
> 847: Error in load file line 1.} What can be the reason of that messages (846, 847) ? It does not matter that
} there is no final comma on line 4.
}
The problem is that you have an empty line at the bottom of the file.
Hope that helps.
Serafim Fonseca
==========================================================================
Serafim Fonseca e-mail: sf@dpx20.growela.pt
Growela Portuguesa Calcado, Lda. phone : +351 2 9820510
S. Pedro Avioso, Castelo fax : +351 2 9812212
4470 Maia - PORTUGAL