Importing data into RevDB
ruslan_zasukhin at valentina-db.com
Fri Dec 4 16:18:40 EST 2009
On 12/4/09 10:46 PM, "David Coker" <davidocoker at gmail.com> wrote:
To fight with line breaks, exists such tip
As to specify as Field and Line delimiters some odd chars
At least Valentina and mySQL allow this.
If SqlLite cannot, you can try to use above dbs as intermediate step.
> Hello folks,
> I'm in the planning stages of a possible new app which will include populating
> a Rev Database (SQLite) primarily from a standard Excel based CSV file. What
> I've run into while doing some research is that that format seems leaves a lot
> to be desired. It seems that the CSV data that I'll be working with has all
> kinds of spurious line breaks and such embedded, so converting to a tab
> delimited format doesn't work well.
> Does anyone have any suggestions as to how to make something like this
> reliable as far as maintaining record integrity during import?
VP Engineering and New Technology
Paradigma Software, Inc
Valentina - Joining Worlds of Information
[I feel the need: the need for speed]
More information about the Use-livecode