John Gregson wrote:
I am using Open Office 3.1.0 (build 9399)
Java version is: 1.6.0_15
I am using a PC with Vista 32
I am very new to Open Office and Base.
Has anybody managed to import a Works 8 database into Base?
I have over 30,000 records, in several Works databases that I
would like to get into Base.
Works 8 can save a database file as a CSV file or as a dBase 4 file.,
or in its own default format.
John.
Hello John,
A couple of suggestions:
dBase is likely your best export format.
When you do the following transformations will happen:
General field type will be exported as TEXT[VARCHAR]
Time fields will export as TEXT[VARCHAR] - this can be a problem if you
really want a time field. Before you export the data select the time
field, select 'Field>Format' from with works menus. Select the 24hour
format (no AM or PM) If you do this then Base will correctly handle a
conversion back to a time data type [either during a final import to an
embedded Base file or via a CAST statement in a query], without needing
a bunch of string manipulations in a query.
Fractions export as DECIMAL [THE DATA GETS MANGLED - 1/2 becomes 2.0 not
.5 - I DON'T HAVE A WORK AROUND FOR THAT]
Serialized fields export as DECIMAL - no hint that they should be
Auto_increment fields.
Ok - otherwise, it is easiest if you export all your tables to a single
directory.
When you create a Base file that connects to dbase files you just supply
the directory name - it picks up all the fiels as tables.
If you create a Base file with an embedded database then you can just
drag the tables from the first base file to the second [be sure to drop
the tables on the TABLE section of the receiving file]
Beyond that - ask if you get into specific transformation issues.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
