Miscellaneous Database Tips

From NeoWiki

Revision as of 10:40, 19 January 2008 (edit) Jgd (Talk | contribs) (→dbf import tip - replace the Search and Replace tip, which doesn't work, with a link to the appropriate article in NeoWiki.) ← 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)
(10 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 several choices:	+
-		+
-	They are described in [[Converting a Text String to a Number in Calc|this article]] in NeoWiki.	+
-		+
-	You can also change the field setting in the DBF from C to N and re-import the file.	+
-	<!--* 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 {{button|More}} button and click the option {{prefName|Regular expression}}.	+
-	*# Click on {{button|Replace All}} and all the apostrophes should be gone.	+
-	Left in comments, just in case…	+
-	-->	+
-		+
-	==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].	+
-		+
-	==Related External Links==	+
-	*[http://wiki.services.openoffice.org/wiki/MSA-Base_Faq OOo wiki article on using Base to connect to Access]	+
-		+
-	{{botlangbarEN|[[Fr:Astuces diverses pour les Bases de Données|Français]]}}<!-- [[It:|Italiano]] [[Es:|Español]]}}-->	+
-		+
-	[[Category:NeoOffice]][[Category:Tips and Hints]]	+

---

Current revision

1. redirect Working with Microsoft Access databases