Make dynamic reports available over internet?

[jdub]

I have a number of Excel spreadsheets that make various menu-driven ODBC
queries to a backend Pervasive SQL database. VBA does the ADODB stuff and
extensive Excel formatting. I'm frequently making modifications and
distributing them to the folks that need 'em.

I'd like to somehow make these available over the internet, so that folks
can access them wherever they are. Not just static reports (trivial via
Excel's publish as web page), but dynamic menu-driven reports.

I've done stuff similar to this using php/mysql, but don't know where to
begin using Excel/odbc/vba.

How do I get started? What technologies do I have to have in place to
accomplish this?

Thanks!

 

[Robin Hammond]

Jdub,

If you have all the logic already sorted in Excel, you could have a look at
using the Office Web Components in a browser. Doing so would allow you to
use your formatting routines, etc.

It's not trivial, but with a bit of work I'm guessing you could create an
interface in a web page that constructs an sql query against the sql server
and returns it to the OWC spreadsheet using very similar code to that you
have already.

You can get the OWC off msdn. The downside is you need the OWC on the client
machines too, but it sounds like you can probably handle this.

Robin Hammond
www.enhanceddatasystems.com