PLC > Database > Excel (via DDE)

Does anyone know a way for me to work from a database, that is linked to serveral PLCs, and somehow using DDE , link Excel to this Database so that I can take information from the database with VB macros, update, and plot graphs using the data from the database?

DDE data can be accessed in Excel by entering: =APPLICATION|TOPIC!TAG as a formula in your spreadsheet.

For example, to get data from a CLX processor into Excel, the formula could be: =RSLINX|PLCNUMBER1!TAGNUMBER1

AK

DDE is 'in' PLC's now? <go figure>

What kind of a PLC are you trying to do this with?

Here are some example codes to download

AB > Access Database
http://forum.mrplc.com/index.php?act=Downloads&CODE=02&id=137

AB > Excel
http://forum.mrplc.com/index.php?act=Downloads&CODE=02&id=134

AB > VB 6.0 with Access
http://forum.mrplc.com/index.php?act=Downloads&CODE=02&id=120

Omron > CX Server DDE Management
http://forum.mrplc.com/index.php?act=Downloads&CODE=02&id=222

I know with some databases that Excel can use MS Query and be directly linked to the database. The phrasing of the question has me lightly confused.

Is the database already established with the info from the PLC going into it? If so just goto the Excel help index and look for database, it will explain how to do it.