Hi :) I think Base is better when you use an external back-end. The Postgresql people made the effort to work with LO devs to make a native connector that is built into LO. MySql is another commonly used database program but it's owned by Oracle so it might be better to go for the drop-in replacement, MariaDb instead of MySql.
The problem with the internal back-end is that it's been known to have issues such as data-loss!! Not good for a database program!! The devs are working at replacing the current ancient, warped version of HsqlDb with an up-dateable version of Firebird but apparently that runs into problems too at the moment, at least last i heard which was several months ago. Base was originally designed to never have an internal back-end but so many people grumbled that it was alien to Access users that the Sun devs tried to squeeze in something but then found they didn't have the time and resources to make a good job of it. So, i think i'd suggest exporting the Tables from Access directly into Postgresql or maybe into MySql/MariaDb. I've forwarded the question to the Users Mailing list to see if anyone there can help Peter with this. Regards from Tom :) On 28 September 2014 05:22, Peter Goggin <petergog...@bigpond.com> wrote: > I am working through the documentation for the forms. To do this properly > I needed a data base. As I have an access data base which I want to convert > to Librebase I used this. I exported the tables from Access as Excel files, > opened them in Librecalc, saved them in native librecalc format. I made > sure the column definitions were correct for dates. > > I copied the data cells and imported them into a Base table. I found a > problem with all fields which were created as text. If I change the date > columns to date format I cannot save the new version of the base table > without losing the date data. Is there any way of importing data and > preserving the data format? > > Many years ago using Oracle SQL I believe you could import text data into > an already created table if your text data had been properly formatted. Is > this possible with LibreBase? > > Thanks for an advice. > > This won't stop me from continuing to reviews the documentation but it > would be good to know how to import data , retaining the formatting and > data types. > > Regards > > Peter Goggin > > > -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/documentation/ All messages sent to this list will be publicly archived and cannot be deleted
