On Thu, 2008-06-12 at 21:12 -0400, Drew Jensen wrote: > Keith Clark wrote: > > On Thu, 2008-06-12 at 20:58 -0400, Drew Jensen wrote: > >> There isn't much to learn..but if you want to hand parse the text lines, > >> by all means go for it. There really is nothing magical about massaging > >> text files into database tables..it is usually just a bunch of grunt > >> type work. > >> > >> You could always dump the data XML instead of CSV...that gives you a bit > >> more flexibility. > >> > >> I have a script that would let you do that - you use a Base file > >> connected to the Calc file and the script just dumps either the entire > >> "sheet as table" or a query result to a simple XML file. No decent UI > >> for the script, but you just add two lines to the file, dbName and table > >> or query name and run it. > >> > > I can try those things, I just don't understand why the same data, from > > one day to the next will have errors. The same database file, with new > > records, creates problems with records that are in the middle of the > > file and unchanged. That makes no sense to me at all. > > > > Keith > > So, you are inserting the records into an existing table? > > If so - by any chance does that table have any constraints, like a PK or > FK's or required fields that can't be null or maybe you created a unique > index on a field and now you are trying to write a duplicate value to > that field.. > > The error message would send you looking for a malformed record, but > sometimes error messages LIE. > I don't think this is an Open Offfice problem. Maybe I'll try someone at phpmyadmin or mysql.
But, thanks as always Drew! Keith --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
