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. 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
