Regina Henschel wrote:
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.
That's true, and it works quite well. But it still is an interactive
approach. If it is a one time import and not too many files it would be
a way to go for sure, if an on going process then scripting I would
think would be a better approach. But, it always comes down to the
specific situation.
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?
Not sure about what problems that might pose. It warants some
investigation, and honestly I have not done it, hadn't even thought to
ask the question.
If I save a Calc sheet as a CSV file I am offered the option of using
the UTF8 encoding for this data, but can't say with any certainty if
there is any problem with this part of the process. Assuming this works
then the HSQLDB engine needs to understand it also. Checking the HSQLDB
documentation it states that the default encoding is ASCII, but they
support an option to the create TEXT table command of "encoding=UTF-8".
So it would appear that yes, this would be supported all the way around,
again however, I have not tested this..not that there is ever a
difference between what the Docs say and what really happens with
software packages..*smile*..
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
