import records from MySQL table

[d_vineet]

Preamble to my question:-

I have a stock-broker's desktop application, from which a csv file is continually being updated on the hard disk.

I am trying to append live stock quotes from the csv file to an OpenOffice Calc file (which is always kept open).
I wish to keep the file open because I will be having stock-charts in it.

A python program which, when run, would append the new data from csv file into a MySQL table.
No problem in that.

My question is---

How do I import data from MySQL table into OO Calc and thereon keep on refreshing it.
For Excel, I figured out how to do it.
In OO Calc, I configured MySQL connection through "Tools--Options--OO Base--Connections".
It opens a window & shows tables.
Can someone pl. tell me how to achieve data-import & refresh from MySQL to OO Calc?
(Copy & paste can't be a good solution).

Thanks in advance,

Vineet

[RPG]

Hello

http://www.oooforum.org/forum/viewtopic.phtml?t=53346&start=0&postdays=0&postorder=asc&highlight=

I think the link give you a lot information.

Romke
_________________
OOo 3.4.5 on openSUSE 12.1
Use this forum : http://user.services.openoffice.org/en/forum

[d_vineet]

Thank you.
It solved my query.
After drag & drop, I did 'refresh range'.

One more difficulty---
After clicking any small table (with as less as 5 rows), it takes very long time to load it (more than 5 minutes).
Any idea what may be the reason?

I am running Win 7 on Intel Core I3
OO Calc ver 3.3
Using ODBC 5.1 driver
MySQL ver 5512

All other things working speedily, except the thing I mentioned (table loading very slow).

Pl. tell me whether you need any further technical info for advising me on this issue.

Thanks in advance.

[dacm]

[d_vineet]

@dacm,
Sorry for not replying in time.
I am formatting my laptop.
After fresh installation, I will follow your instructions and let you know the result.

Thanks,

Vineet