Thanks Drew That seems useful. I'm assuming the * is meant to be after the SELECT, rather than before the FROM?
Is a csv just text? Do I need to CREATE and SET TABLE in SQL first, as I can't see a way to do it with design view or Wizard? I'm struggling with this, as it's the first one I've tried to do in SQL. Essentially I want 9 fields all text except for one date I need a combined primary key covering 3 of these (possibly 4 for correct sorting), which may need an extra field. This is required for forcing unique records, as individual fields may be duplicated. I'm also guessing I may need "ALL QUOTED" option Roughly what would the full process look like? Thanks again, Ed From: Drew <[email protected]> To: [email protected] Content-Type: text/plain; charset="UTF-8" Date: Tue, 05 Oct 2010 00:04:52 -0400 Message-ID: <1286251492.11698.29.ca...@sybil> Mime-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: Re: [users] Exporting a database On Tue, 2010-10-05 at 01:48 +0100, Ed Warne wrote: > Hi > I'm trying to convert my Open Office database to Lotus Approach. > As I understand it, the recommended way of doing this is via Open Office > Spreadsheet and thence to a text file. Assuming this is a file with an embedded database. Open your base file. Open he SQL window In the window execute a SQL command to export the file. ie. SELECT INTO TEXT 'mydata.csv' * FROM "MyTable" You can find details for the TEXT file support in the HSQLdb documentaiton at http://hsqldb.org HTH Drew > When I do this, fields get converted into the wrong format. Text fields which > contain only numerics convert to numeric fields, those containing the format > 123AM convert to time format. > The conversion seems to be done despite the format of the cells in the > spreadsheet being "text". The subsequent delimited text file then has merged > or incorrect fields. > Is there a way of preserving the correct format and fields? > > eg > Where the bottom line field 2 should be 385AM and fields 2 and 3 of all > should be text left aligned N 380TT GS3 > LBG 13/06/99 C > 3 > N 381AN 767 AA RIN 23/01/95 Y > 3 > N 38273 PA28 WARRIOR > BAR 24/09/94 N > 5 > N 382AN 767 AA RIN 22/10/94 Y > 3 > N 382AS C 172 > BAR 12/05/02 N > 3 > N 3839H PA60 > PLY 08/08/99 N > 4 > N 383AN 767 AA RIN 23/09/94 Y > 3 > N 384AA 767 AA RIN 08/03/95 Y > 3 > N 16.04 767 AA RIN 26/10/94 Y > 3 > > Thanks > Ed ? ?
