EXCEL WebPages and SQL Database!

[iahiii_2005]

Hi All,
I am really in a bind,any help would be really appreciated.
Here is the project i am working on:
I am collecting data to a SQL database using Factorytalk transaction from Contrologix PLC.
Is there a way to populate a MS Excel based webpage or Excel Sheet that autorefreshes as i get new data?
Basically the excel sheet would have static text and empty cells...which will be populated based on the data retrieved from SQL Database?
Can the Excel Spreadsheet autorefresh,to get new data as it gets it.
Thanks and please help me

 

[surferb]

Webpage based on SQL database can work fine. Autorefresh can be tricky to do well (AJAX, Flash, Java, etc), but can be done cheesy (Auto-refreshing Meta tag, etc). You can statically save web pages from Excel, but don't expect this to auto-refresh/populate without a whole lot of effort - and it probably won't ever be stable.