Hi :) Ok, so the Documentation Team have got an example database for Peter to work with in the short-term but the question of how to migrate an Access Database would still be good to get some hints and advice on.
Is there anyone who can help with this? Regards from Tom :) On 28 September 2014 09:13, Tom Davies <[email protected]> wrote: > Hi :) > Errr, obviously if he's using Access then it must be Windows. The only > other platform that MS Office has been able to port to was Mac and they > weren't able to port Access were they? > > Anyway, i think that mean Peter could use some help porting an Access > database to either Postgresql, MySql/MariaDb or into Base itself and on > Windows. > Regards from > Tom :) > > On 28 September 2014 09:09, Tom Davies <[email protected]> wrote: > >> 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
