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 --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
