Auto Manual Online

Sponsored Links

 

 

 

HOW-TO use Microsoft Access databases from within OpenOffice.org 1.1

Source: www.openoffice.org
Topic: Microsoft Office


Short Desciption:
HOW-TO use Microsoft Access databases from within OpenOffice.org 1.1 Open Office. org (OOo) is able to read and write from a wide variety of databases, as long as they support one of the standard ...

 

Content Inside:
HOW-TO use Microsoft Access databases from within OpenOffice.org 1.1 Open Office. org (OOo) is able to read and write from a wide variety of databases, as long as they support one of the standard interface specifications such as ODBC or JDBC. Fortunately, Microsoft Access (MS-Access) supports ODBC. This HOW-TO takes you step by step through the process of linking OOo to MS-Access using ODBC. The process has three simple steps: 1. Create an ODBC Data Source for each database you want to use (you only need to do this once per database) 2. Create an ODBC Data Source within Open Office. org for each database (you only need to do this once) 3. Enjoy using your MS-Access databases in OOo! Creating an ODBC Data Source for the MS-Access database Within MS-Windows, choose Start -> Settings -> Control Panel and double-click the ODBC Data Sources icon to run the ODBC Data Source Administrator: of 4 26.02.2004 Click on the Add button to display the Create New Data Source dialogue box: Select the Microsoft Access Driver and press the Finish button. This will display the ODBC Microsoft Access Setup dialogue box: Give the new data source a name (e. g. the same name as your MS-Access database) and a description.  Use the Select button to select your MS-Access database file (*. dbf)  and press OK . of 4 26.02.2004 You should now see the ODBC Data Source you have created listed in the ODBC Data Source Administrator : Click OK to close the Administrator. Note that every database you want to use in OOo will need to have its own ODBC Data Source defined here. Creating a Data Source within OOo From within an OOo application,  select Tools -> Data Sources. You will notice that OOo comes with one pre-installed Data Source called Bibliography .  Ignore this, and press the New Data Source button Select Database Type ODBC , and press the select button [. ] and choose the ODBC Data So ...

 

add to Google Reader add to Google Bookmark add to bloglines add to newsgator add to FURL add to digg add to webnews add to Netscape add to Yahoo MyWeb add to spurl.net add to diigo Bookmark newsvine Bookmark del.icio.us Bookmark @ SIMPIFY Bookmark MISTER WONG Bookmark Linkarena Bookmark icio.de Bookmark oneview Bookmark folkd.com Bookmark yigg.de Bookmark reddit Bookmark StumbleUpon Bookmark Slashdot Bookmark blinklist Bookmark technorati add to blogmarks add to blinkbits add to ma.gnolia add to smarking.com add to netvouz add to co.mments add to Connotea add to de.lirio.us

 

Related PDF Files

Using Microsoft® Office Excel® 2007 Exam Guide


Topic: Microsoft Office

Using Microsoft® Office Excel® 2007 Exam Guide Preparation Recommendations Step 1: Assess your skills: Prepare for the Using Microsoft Excel 2007 Application Specialist certification exam by taking ...

2004 Credit by Examination Guide -- Sample pages: Microsoft


Topic: Microsoft Office

130 Microsoft ® Office Specialist Certification Program 2004-2005 Guide to Educational Credit by Examination Microsoft ® Office Specialist Certification Program Review Date: October 2002, March 2003 ...

An Introduction to VBA in Excel


Topic: Microsoft Office

This is a tutorial showing how to use the macro facility in Microsoft. Office—Visual Basic for Applications—to simplify analytical tasks in. Excel. Contents ...

Microsoft PowerPoint Introduction


Topic: Microsoft Office

Microsoft PowerPoint Introduction Version: 1.1 September 30, 2004 Internal Use Only A publication of the Archdiocese of Chicago Office ... template (Default design) is extremely plain. Design Template If you ...

Microsoft Office Compatibility


Topic: Microsoft Office

... Microsoft Office Compatibility MailRoom ToolKit Specifications MailRoom ToolKit Series Installs instantly into Microsoft Access, Excel and Word. Instant and seamless integration within Microsoft Office. The ...

 

Sponsored Links