OT - convert m$ access files to openoffice base

[Jim Cornette]

Craig White wrote:
> On Fri, 2006-03-10 at 20:52 -0500, Jim Cornette wrote:
>> kevin.kempter at dataintellect.com wrote:
>>> Anyone know of a reliable way to convert m$ access data to openoffice base?
>>>
>> I tried and did not have positive results with the process. 
>> Openoffice.org MSwindows and Openoffice.org for Linux had different 
>> database structures when I tried. The tables converted somewhat on the 
>> windows side but did not function on the Linux side.
>>
>> They might have some solutions for compatibility from OS to OS. I tried 
>> when the openoffice.org-base package first premiered.
>>
>> The most success that I had was when exporting the tables to excel and 
>> then exporting the spreadsheets to openoffice.org format. I stopped the 
>> attempt since it seemed quite a bit more of a challenge than expected.
>>
>> If anyone has met with success when trying to convert MSaccess DBs over 
>> to Openoffice.org-base (windows-bound) and then over to Linux, I am 
>> interested in this possibility also.
>>
> ----
> you might want to check out...
> 
> http://mdbtools.sourceforge.net/
> 
> Craig
> 

Thanks! I bookmarked the link and might try to convert the mdb files 
over to another database format. The challenge to outcome might be lower 
and acceptable to net results.

Jim