English
Ask Your Question
0

Importing and creating relationships in base

asked 2013-08-12 19:09:42 +0200

So I have an .xlsx file I need to import into Base. It has two tables and I need to create a relationship between the two tables. I can import the file just fine by opening it in Calc first, saving it, then connecting to it when I open Base. However, when I try to create a relationship I get the error "This database does not support relations."

What do I need to do? What am I doing wrong?

edit retag flag offensive close merge delete

Comments

1

Perhaps you should save it as LO Base file? If you, somehow, open LO Calc file in Base, Calc file does not support relationship as does LO Base file.

Ljiljan ( 2013-08-12 20:52:18 +0200 )edit

I am having the same issue as well. This advice doesn't solve the problem for me. I recreated my XLSX as a ODS file, imported it into Base and got all the tables. But when I try to run a join or add a relationship, I am not able to because of the same error above.

Christine ( 2013-11-07 17:55:56 +0200 )edit

1 answer

Sort by » oldest newest most voted
1

answered 2013-11-07 18:48:22 +0200

updated 2013-11-07 18:48:59 +0200

Hi there, I had the same problem. I found my answer here:

https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=5687

It's not that the relations can't be done, it's that something goes wrong with the import process, so copying and pasting the tables over helps.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

Follow
1 follower

Stats

Asked: 2013-08-12 19:09:42 +0200

Seen: 161 times

Last updated: Nov 07 '13