On Fri, 2007-04-13 at 21:02 -0700, NoOp wrote: > On 04/13/2007 08:24 PM, NoOp wrote: > > On 04/13/2007 03:20 AM, Dan Lewis wrote: > > > >> There have been some improvements made in Base since version > >> 2.02. You might want to update it to 2.2. Also, where did you get > >> version 2.02? If you got it from Kubuntu, it might have been modified > >> somewhat from the original version from OpenOffice.org. How much RAM > >> do you have on your machine? What were the fields and their field > >> types in the table you were trying to create? I would like to see if > >> I can recreate what happened to you, but I need to know what was in > >> the table that caused the SQL 3700 error. > >> > >> Dan > > > > That version of Kubuntu (6.06) is in what Ubuntu calls 'Long Term > > Support' meaning that they don't make any changes unless absolutely > > necessary. I've had to&fro's on the Ubuntu lists regarding the problems > > with keeping OOo at 2.02, but it tends to fall on deaf ears. Best bet > > would be for the OP to simply download & install 2.2 directly, or to > > upgrade to Kunbutu 7.04 (now in beta). > > > > As for the Access conversion; I believe that Michael Adams hit the nail > > on the head. There is no MS Access conversion option (even in 2.2) for > > linux in the standard OOo version. So he may have to try that or the > > following: > > > > There *is* however one in the Ubuntu 2.2 version that is now distributed > > with Ubuntu 7.04 (beta) (same distro version that also can open MS Works > > text documents)... go figure. I've not tried it yet - if I get a chance > > later I will (I'm packing to go sailing for the weekend). > > Update: > > I just tried importing a Win98/Access97 database into the linux Ubuntu > 7.04 2.2 OOo and it works. As a test I just imported the MS sample > "Northwind" database that was included with Access97. So the OP should > be able to do this if he upgrades to Kubuntu 7.04 (not recommended at > this time for a production system as 7.04 is a newly minted beta). > > Now the questions would be: 1) why is this MS Access database option not > available in the OOo 2.2 linux version, 2) ditto for the MS Works import > text document filter? >
It would seem that neither are officially implemented yet http://dba.openoffice.org/drivers/index.html http://www.openoffice.org/issues/show_bug.cgi?id=8938 The inclusion appears to be distro specific. I use OOo 2.1 on Gentoo and have the MsWorks filter but not the MsAccess option. To work with MsAccess files I use the commandline mdbtools or more recently the Kexi graphical database which uses a mdbtools plugin to import MsAccess tables and can export to .csv. Barrie --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]