Hi, export tables from MSACCESS as dbase files in a proprietary directory. Connect to that directory from LO-base.
Yours Walther as Am Sonntag, 28. September 2014 schrieb Tom Davies: > 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 <tomc...@gmail.com> 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 <tomc...@gmail.com> 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 <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: users+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/users/ All messages sent to this list will be publicly archived and cannot be deleted
