Jonathan Dixon wrote:
I would like to be able to initially populate a relational HSQLDB database using a CSV file. Specifically, I would use a file that looked like this:
I'm in the middle of this, and I have a request, so I'll take a crack at an answer: use a spreadsheet. This sequence is already supported:
CSV -> Calc (split into two sheets) -> data source -(copy/paste tables)-> HSQL database
That looks like a lot of work, but each of the steps is pretty straighforward.
Now, my request is for more flexibility in the last step. I set the formatting in my spreadsheet cells to 'text' ('@'), so I could be sure to see exactly what was in them (numbers with fixed #digits, e.g.). When I create an .odb data source from the sheet, the fields all get set to varchar type. Then when I paste the data into my HSQLDB table, it says 'There was an error, do you want to continue copying?', but no data are copied at all. I assume it's balking at converting varchar -> integer, even though the values are all numeric.
I find it very helpful to be able to use a spreadsheet for the initial db design. It's far easier to make changes and get everything the way you want it then import it into Base. There's a big statement there about ease of use, but for now it would be great if the process of importing from Calc -> Base was made to 'just work'.
I'm really impressed with how Base is coming along: good job guys! <Joe --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
