Ask Your Question
0

Connect Calc to a MySQL

asked 2017-07-06 12:12:58 +0200

ZioRiP gravatar image

Hello, I am browsing since days now, maybe I don't know what to look for, but I am unable to find a way to connect my calc spreadsheet to a MySQL database that I have created. I would like to avoid using base and connecting directly to my online SQL database, but I don't see how. This is something that needs to be used by another person, not me, so ideally they should connect seamlessly to the database, whenever running the file in calc. Could anyone help me, please? Thanks in advance :)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2017-07-06 16:13:56 +0200

Ratslinger gravatar image

Hi,

Getting MySQL database information into Calc requires the use of Base. Base is used to make the actual connection to the database. See Chapter 2 Creating a Database in the Base handbook for connection information - click here.

Once the connection is established, whatever tables or queries are available in Base can be available in other LO products such as Calc or Writer. This is done by registering the Database in LO. You can see more on this in the Calc guide Chapter 10 Linking Calc data - click here.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-07-06 12:12:58 +0200

Seen: 7,914 times

Last updated: Jul 06 '17