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.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
