question

DDE avatar image
DDE asked

Export DDE / RTD data from Excel to web page possible?

Hi, I would like to know if it is at all possible to create a dynamic web page which displays cell data retrieved from an excel file which is linked to a DDE / RTD data feed (like real time stock quotes), and if an SQL sever would have to be used for it? And if you may have an idea of the maximum amount of money I should expect to pay a web developer for creating such a web page (so I know if someone might be overcharging me)? For example: DDE/RTD data from a program --> Excel --> Access --> SQL Server --> Web Page ? -or- DDE/ RTD from a program --> Excel --> Web Page ? Thanks!
excelmicrosoft-accesswebinterface
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Wimbush avatar image
David Wimbush answered
Does Excel do anything with the data or is it just the current method of enabling users to view it? Unless this feed is something really strange, I'm fairly sure any decent web developer would be able to read it and display the data on a page. I doubt that Excel or SQL Server need to be involved. How much money for that? It depends on exactly what type of feed this is, how complicated the data is, and what country you're in. My guess is that it feels like 2 or 3 days work but you haven't given much information to go on.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered
You can use Excel as a data source for SSRS so you could build a report that takes the Excel data.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Daniel Ross avatar image
Daniel Ross answered
A few years back I created a small vb script behind the "save" event in excel, and the script uploaded the data to a database(doesn't have to be MSSQL, any DB connected to the website will do), so what happened is that as soon as the user saved their spreadsheet, the web was updated straight away. Had issues with them changing the columns names a couple of times, but once they realised that their web data would break, they stopped doing it pretty quickly. Only took a day to do. but a more robust script (checking columns names etc and not updating if changed) would take a coupleadays.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered
Sounds like the data might lend itself to [StreamInsight][1]. StreamInsight is a framework that allows for real time data to be captured into SQL Server, so in your scenario could give you: DDE/RTD data from a program --> StreamInsight --> SQL Server --> Web Page Downsides are that you will need to be on the latest SQL Server version - 2008R2. It doesn't really matter what edition - as the actual code/features/call-it-whatever you like, is just a bunch of DLLs that give you the base on which to build. Might be worth a look, if only just to discard the idea...... [1]: http://www.microsoft.com/sqlserver/2008/en/us/r2-complex-event.aspx
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.