Am Freitag, den 31.08.2007, 13:23 -0400 schrieb Dinbandhu: > Hello everyone, > I've just joined this mailing list today. I've been struggling to import > my first MS Access file into Linux (Ubuntu) OO Base for the past 2-3 > days, without success. I've actually described the entire tale on the > [EMAIL PROTECTED] list. Drew has given me some very helpful tips; > yet up till now I could not get success. Don't know if anyone has a > moment to take a look at the [EMAIL PROTECTED] archive for the > past two days and could let me know their thoughts on how to get an > import done. Also, when I just do a 'connect to preexisting file', then > the result is a "read-only" file. Don't know why.
Not having followed the complete thread on [EMAIL PROTECTED] I can add some small hints: Having the access database in an .odb writable only worked when switching the connection type from ADO to ODBC. In windows I registered a user connection in the ODBC-manager and used that from OO.o. Copying from this .odb showing the access tables showed up two things in a quick test. I used drag & drop to copy tables from the access base window to the target base window: - If the primary key is based on a text column, OO.o-base doesn't like it (read: doesn't add the PK itself). This was solvable by ignoring the fact there is no primary key and editing the table definition in the target .odb later only setting the text column to "primary key". - Importing truth values (aka boolean values) the column produced an error when copying. I deleted the empty table in the target doc and started once again, this time setting the vachar(1)-column to a boolean value column in the wizard and the import worked flawlessly. My setup is made of Win98se, OO.o 2.2 and an old access .mdb. I cannot tell which version of access was used to create it, must be one of Acc95, Acc97, Acc2k. Concluding I have to say it is not trivial to import tables from Access to OO.o/HSQL but it's not that hard to get it done, at least for a well trained user having some basic db knowledge. HTH, Marc --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
