Miscellaneous Database Tips

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 16:10, 18 January 2008 (edit)
Lorinda (Talk | contribs)
(add link to OOo wiki article on same subject)
← Previous diff
Revision as of 20:54, 18 January 2008 (edit) (undo)
Jgd (Talk | contribs)
(botlangbar to Fr page)
Next diff →
Line 31: Line 31:
*[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]
-<!--{{botlangbarEN|[[Fr:|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 20:54, 18 January 2008

This article is not up to date, or it needs structural or stylistic changes to conform with the rest of this wiki.

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.

dbf import tip

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 two choices.

  • Change the field setting in the DBF from C to N and re-import the file or
  • use the Search and replace functionality.
    1. Open the search and replace dialog and enter '.*' (without the quotes) into the search field.
    2. Type '&' (also without quotes) into the replace field.
    3. Now press on the More button and click the option Regular expression.
    4. Click on Replace All and all the apostrophes should be gone.

MS 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.

An ODBC driver that works with MS Access on a Mac is the Actual ODBC driver. It is a commercial one, but it works. 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). Other options are discussed on the Trinity forum.

Related External Links


This article in other languages: Français
Personal tools