On Fri March 10 2006 15:35, + Jay Heiman wrote: > 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.
As you are not subscribed you may not have seen that: On Sat March 11 2006 01:49, Jean Hollis Weber wrote: > > That information is for OOo 1.X and should be updated. I don't > usually take care of the FAQs, but I'll put it on the list to do. > > Meanwhile, the good news is that it's much easier to do this in > OOo2.x. This is covered in Chapter 10 of the Getting Started Guide, > http://documentation.openoffice.org/manuals/oooauthors2/0110GS-GettingStartedWithBase.pdf > Please reply to [email protected] only. -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
