Miscellaneous Database Tips

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 03:58, 21 July 2007 (edit)
Sardisson (Talk | contribs)
m (no need for the header now)
← Previous diff
Current revision (06:58, 28 February 2009) (edit) (undo)
Sardisson (Talk | contribs)
(redirect this to the new MS Access page, since that's why we linked to this page most of the time)
 
(14 intermediate revisions not shown.)
Line 1: Line 1:
-{{fixme}}+#redirect [[Working with Microsoft Access databases]]
-<!--These tips are copied from the old Configuring and Using Databases page-->+
-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.+
- +
-1.) Change the field setting in the DBF from C to N and re-import the file or+
-2.) use the Search and replace functionality. Open the search and replace dialog+
-and enter '.*' (without the quotes) into the search field. Type '&' (also+
-without quotes) into the replace field. Now press on the More Button and tag the+
-option Regular expression. 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 [http://www.actualtechnologies.com/product_access.php Actual] ODBC driver. It is a commercial one, but it works. The [http://www.mysql.com/products/tools/migration-toolkit/ MySQL Migration Toolkit] for the Mac can be found in the [http://dev.mysql.com/downloads/gui-tools/5.0.html 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 [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=23436#23436 Trinity forum].+
- +
-<!--{{botlangbarEN|[[Fr:|Français]] [[It:|Italiano]] [[Es:|Español]]}}-->+
- +
-[[Category:NeoOffice]][[Category:Tips and Hints]]+

Current revision

  1. redirect Working with Microsoft Access databases
Personal tools