|
|
Miscellaneous Database Tips
From NeoWiki
| Revision as of 06:09, 27 February 2009 (edit) Sardisson (Talk | contribs) (→MS Access-related tips - some polish here, add Ed's new find, clarify that no-one has tried these) ← Previous diff |
Revision as of 06:09, 27 February 2009 (edit) (undo) Sardisson (Talk | contribs) (→Related External Links - Win-only) Next diff → |
||
| Line 58: | Line 58: | ||
| ==Related External Links== | ==Related External Links== | ||
| - | *[http://wiki.services.openoffice.org/wiki/MSA-Base_Faq OOo wiki article on using Base to connect to Access] | + | *[http://wiki.services.openoffice.org/wiki/MSA-Base_Faq OOo wiki article on using Base to connect to Access] (currently requires Windows) |
| {{botlangbarEN|[[Fr:Astuces diverses pour les Bases de Données|Français]]}}<!-- [[It:|Italiano]] [[Es:|Español]]}}--> | {{botlangbarEN|[[Fr:Astuces diverses pour les Bases de Données|Français]]}}<!-- [[It:|Italiano]] [[Es:|Español]]}}--> | ||
| [[Category:NeoOffice]][[Category:Tips and Hints]] | [[Category:NeoOffice]][[Category:Tips and Hints]] | ||
Revision as of 06:09, 27 February 2009
The following are miscellaneous database-related tips which currently do not have enough content to warrant a full article and which have no other home.
Contents |
dbf import tip
Connecting to dbf files in Base
You can use Base to connect to one or more dbf files.
- Go to the File menu and choose New and then Database
- In the first pane of the Database Wizard, Choose Connect to an Existing Database
- Set the drop-down to dBase
- Click Next>>
- In the next pane, click on the Browse button
- Navigate to the folder in which the dbf files are found
- You cannot choose a file, you must select a folder.
- Click Open
- Click Next>>
- In the Save and Proceed pane, select the settings as desired
- Click on Finish
importing into Calc
The table structure of the dbf file for all the fields containing leading apostrophes say they are characters. This can easily seen if you import the DBF file and look at the first row. All columns have a header defining it. C is for characters (text), N would be numeric.
So Calc imports the values correctly as Characters. As the number format for the default template is set to numeric, a apostrophe is placed in front of the value to make it a text.
To change such text values to real numeric values, you have several choices:
They are described in this article in NeoWiki.
You can also change the field setting in the DBF from C to N and re-import the file.
Issues with DB2K files
older dbf files in the DB2K format are not compatible with NeoOffice or OpenOffice.org. When the connection is made, most fields will show <OBJECT> for data in Base and #N/A in Calc. If you have a Windows machine available, the solution is to use the dbf-converter program to convert these files to dBase-IV format, which NeoOffice does support.
Microsoft Access-related tips
Well, a lack of drivers will definitely cause files to not be openable. Anything that requires the MS ODBC bridges won't work for sure, including Access files.
N.B. To our knowledge, no one has tried any of the potential solutions below to verify that they work with NeoOffice.
An ODBC driver that works with MS Access on a Mac is the Actual ODBC driver. It is a commercial one ($29), but it works with Access.
The MySQL Migration Toolkit for the Mac can be found in the MySQL GUI Tools Bundle and can be used to move data from an MS Access database to a MySQL one (which NeoOffice will happily deal with).
StelsMDB is a commercial ($110) MDB JDBC type 4 driver that allows to perform SQL queries and other JDBC operations on Microsoft Access database files (MS Access 2000, 2002, 2003, XP versions). Presumably NeoOffice could use the JDBC driver to connect to the Access database.
Other options are discussed on the Trinity forum: [1], [2].
Related External Links
- OOo wiki article on using Base to connect to Access (currently requires Windows)
