OK, I'm using OO 2.0.2 I checked the FAQ etc. and got this info: How do I access my Microsoft Access database files in OpenOffice.org?
StarOffice 5.2 had a possibility to access Microsoft database directory (by chosing the respective database type). You can still reach the same with OpenOffice.org 1.x, but some names and some syntax changed .... * You need the Microsoft Jet Engine for accessing MS Access database files. It is part of the HYPERLINK "http://www.microsoft.com/data/download.htm"Microsoft Data Access Components MDAC. Download the latest version of this package and install it. * Second, go to Tools/Data Sources, and in the upcoming dialog create a new data source of type ADO, and as URL enter PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=<path_to_mdb_file> (The "<"/">" belong to the "variable" - when replacing the path, this should result in something like "Data Source=C:\AllMyFiles\MyDB.mdb"). * Then, apply the changes done to the data source, and enjoy working with your MS Access database :) There's an alternative way to access Microsoft Access databases, by using ODBC. For a detailed explanation of how to do this, see John McCreesh's step by step illistrated guide, reference from HYPERLINK "http://www.openoffice.org/FAQs/mostfaqs.html#10"OpenOffice.org's main FAQ site Unfortunately it appears 2.0 isn't quite the same menu layout and I can't find an appropriate spot to perform this action. (Tried insert-link to external data) and tried adding an ODBC data source as described in McCreesh's instructions but am still not getting anywhere. Could someone possibly submit a new set of instructions for OO 2.0 describing how to connect to an MS Access MDB. My problem is the National Resource Conservation Service now provides only MS Access database templates for all their soils data. I just ran across OpenOffice and would love to be able to dump MS Office. This looks like a prime candidate if I can get the functionality I'm currently using to work. Thanks for any assistance. Jay Heiman, P.E., CFM Civil Engineering Solutions, Inc. 1325 Howe Avenue, Suite 202 Sacramento, CA 95825 Ph. (916) 563-7300 Cell (916) 599-6268 Fx. (916) 563-7362 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.0.375 / Virus Database: 268.2.1/278 - Release Date: 3/9/2006
