reading data from wincc db

tim_hsmn

hello everyone

i 've been busy on a project in wincc to measur voltage, capacity etc with a simeas p (power meter).
All the data that comes in is transformed in a graphic and all the maesured data is saved in the archive.

in Wincci'veuseda function to look back in the history of the archive to collect data and show them in the graphic.

Now is my question how to put that data into excel with onepush on a button.
Iv'e triedseveral programs to look back in thehistory of the archive butnothing works.

I'm using wincc V6.0
industrial databridge V6.0 sp1
tried excel query

hope someone can help me

greetings tim

tim_hsmn

hello rit03

thank you for your quick respond, the link is great only i hoped there is just a program excisting in wincc that makes this also possible, like databridge or something like that or excel query.

greetz tim

hello rit03

sorry but the link does not work.

tim_hsmn

hello rit03

sorry but the link does not work.

tim_hsmn

thank you, but i've seen this link and i've tried that butthis function of databridge writeseveryruntime data that is coming in wincc straight to excel every several miliseconds.

buti won't to write only the data from the history of the archive that i select like example:

from date: 28-09-08time:10:02:30
to date: 30-09-08 time: 12:02:18

to do this is not the problem because that's a function within wincc but to write just that data to excel or acces is the problem.

greetz tim

tim_hsmn

thank you but no, i'm sorry that website don't helping me either, i already looked there.

greetz tim