Am Montag, den 30.05.2005, 16:11 -0500 schrieb Jonathan Dixon: > 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: > > LastName, FirstName, Unit, Position, MemberID, Status > > to populate a Members table containing > > LastName FirstName MemberID (other info) > > and a Unit table containing > > Unit MemberID Position Status (other info) > > > I recognize that this will almost certainly require scripting. Could someone > give me pointers on where to start?
Not necessarily: The most common average users way would be: 1. Import your .csv into Calc and in the import dialog set the column types correctly. 2. Open the Database Browser and connect to your attached database. 3. Grab the complete table in Calc by left klicking on the empty table header block (the spot where row headers and column headers meet between "A" and "1"). 4. Drag the whole table over the database and see the cursor changing to an arrow with an attached "+"-sign when over the "tables" node. 5. Drop it. Now you have a newly created table with the column names from the first line of the calc sheet. Maybe at some point an import wizard starts and will assist you. HTH, Marc --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
