Re: [dba-users] Importing or copy spread sheet data into a OO Database Table

[Andrew Jensen]

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. 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 and Import CSV