Hallo Andrew,
Andrew Jensen schrieb:
Regina Henschel wrote:
Hello SOTL,
SOTL schrieb:
[..]
I would like to place the content of these spreadsheets into
database. For simplicity I was using the standard OpenOffice
database. the question is how does one import one of these
OpenOfficespreadsheats into a table or how does one copy and past one
of these spreadsheats into a table?
Have you already tried
http://dba.openoffice.org/FAQ/FAQ.html#import_spreadsheet ?
Under 2.0.1 that technique will not work, Base will crash openoffoce.
You can work around it, when you first define the table in Base (don't
forget primary key) and then append data in the import dialog.
Your better bet is to export the worksheets as csv files and import them
using the TEXT table feature of the HSQLDB engine. If the spreadsheets
are in a common format then this will be relatively easy. You can find
threads dealing with this on the OOOForum site. Two of these threads are:
mailmerge
<http://www.oooforum.org/forum/viewtopic.phtml?t=29915&start=0&postdays=0&postorder=asc&highlight=csv>
and
Import CSV
<http://www.oooforum.org/forum/viewtopic.phtml?t=25434&start=0&postdays=0&postorder=asc&highlight=baseball>
Does this allow to use utf-8?
kind regards
regina
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
