Hi :) Many thanks to Walther Koehler-4 and Paul-6! :)) Peter Goggin has been able to do the transfer. So i have copied all the answers in below to try to help make this easier to solve next time. Many thanks and regards to all! :) Regards from Tom :)
Peter Goggin wrote > I finally solved how to transfer the data from Access to Base. The steps > are very simple and work well. During the creation stage I did not > realize that while the Create button was available there was a Next > stage also available where the data types of the newly crated table > fields can be modified. (May be the Create button should not be > available until the data types have been checked) Setting the date > fields to date and the other fields to correct types solved the > problems. Since my "ACCESS" data base allows me to fully check the forms > documentation I will continue using this in parallel with the proper > sample data bases. > > Regards > > Peter Goggin Walther Koehler-4 wrote > Hi, > > export tables from MSACCESS as dbase files in a proprietary directory. > Connect to that directory from LO-base. > > Yours > > Walther > <snip /> Paul-6 wrote > I've got some experience with various databases, but little with > Access, sorry. > > Given the OP exported the data from Access once, I'd assume that it's > possible to export to csv format instead of Excel spreadsheets, and I'd > recommend that. Then importing into Base should be straightforward, and > formatting shouldn't be lost. Access might even give some options for > the export formats, but worst case the data can be massaged in Calc > before importing into Base, say to change the date format. > > If the OP is still having trouble with this, he can try posting a > couple of lines of the exported csv file, and we can see if there is a > reason Base is not importing it correctly. > > This does sound like it should be possible with the method he is using, > but it's much harder for me to debug. If he's using plain csv files, > just posting a couple of lines would give me an idea of how the data > looks, and I could test on my machine, which does have Base, but not > Access. > > And if he wants to go to MySQL/MariaDB/PostgreSQL, again using csv > files should be pretty straightforward, even if it does mean command > line and queries, and not a GUI interface. Although those exist, I'm > just not as familiar with them. > > Paul > > <snip /> -- View this message in context: http://nabble.documentfoundation.org/Re-libreoffice-documentation-Re-Base-Document-Forms-tp4123900p4124035.html Sent from the Users mailing list archive at Nabble.com. -- 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
