Hi :) Has anyone here got experience with migrating Access databases to Base?
I have a strong feeling that migrating the Tables to Postgresql or MySql/MariDb would be a better first step. I'm not sure what platform Peter is on, sorry. Regards from Tom :) On 28 September 2014 05:22, Peter Goggin <[email protected]> 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: [email protected] 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/users/ All messages sent to this list will be publicly archived and cannot be deleted
