Importing .xls table into Base

users
#1

I've exported my tables from MSAccess as .xls spreadsheets. I've created a
new database in LO Base but I can't find the option to import these .xls
tables into Base. I can see options to link tables but I was expecting to
import them into a database the same as Access does.

This is the first time I've strayed into LO Base having moved to LO a year
ago. Now I'm trying to move databases over. BTW I'm an experienced user of
MSAccess/databases.

Regards
David

#2

Drag and drop betweeen calc and base.

#3

Hello,

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)

Julien

#4

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

#5

Hi :slight_smile:
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 :slight_smile: