Hi :) I think Base is best when you keep those tables externally, preferably in a dedicated database program such as MySql / MariaDb, Postgresql, HsqlDb or any of the other ones. Access is not so good at linking to external sources for it's data so it's quite a radical difference between Access and Base. It means Base is much easier to upscale (or downscale) just by swithcing which back-end program is storing your data.
The link didn't work very well for me either. The close-bracket at the end seems to have grabbed the f which radically changes the address and just got me something like a "404 Page does not exist" error. It might be better to look through the wiki's Faq about Base https://wiki.documentfoundation.org/Faq Also the official documentation has a handbook and the 1st 3 chapters of the guide. https://wiki.documentfoundation.org/Documentation/Publications I wonder if the pdf link works better like this? * https://wiki.documentfoundation.org/images/e/e8/BH40-BaseHandbook.pdf Regards from Tom :) On 16 December 2013 21:22, dollyp <[email protected]> wrote: > julien2412 wrote >> Taking a look to the documentation, I read this: >> "Exporting data from Calc into a database >> Select the data in the Calc worksheet. Hold the left mouse button down and >> drag the data that you >> want to turn into a database into the table area of the database browser. >> " >> (see >> https://wiki.documentfoundation.org/images/e/e8/BH40-BaseHandbook.pdf) > > Sorry I can't find this info in the document you linked to. There are > several paragraphs about linking to spreadsheets but that's all I can find. > > Nevertheless, thanks to both responders for the information, which proved to > be what I needed. I would say that for folk coming to Base from Access, the > lack of a menu option for 'import' does not help. To be fair, select/paste > is more intuitive and a plus for Base. > > Again thanks > David > > > > > -- > View this message in context: > http://nabble.documentfoundation.org/Importing-xls-table-into-Base-tp4088116p4088435.html > Sent from the Users mailing list archive at Nabble.com. > > -- > 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 > -- 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
