Downloading Excel spreadsheet to client

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

We have data in a MS SQL database that our client wishes to access for
analysis purposes. They would like to view the data in an Excel spreadsheet
that they can download over the web. The spreadsheet contains two pages:
Page 1) Raw data, Page 2) Pivot Table based on raw data. The user should be
able to specify filter parameters for the data returned such as start date,
end date, facility code, etc. Our current environment includes MS IIS
running ColdFusion to dynamically create and serve pages over the web.

The big question is: Can we dynamically create the Excel spreadsheet, given
the required input parameters, on the server? And if so, what are the steps
to do this? Does any one have any helpful tips of how best to go about
solving this situation?

Thanks!!!
 
Kevin,

I don't know of a commercial tool that extracts SQL data into a fully
functioning Excel workbook.

If you're looking for how to do this, you can use Excel's automation
layer to accomplish it from a technical perspective.

If you're looking for software vendors that can help with tools, see
http://badblue.com/helpxls.htm for one such vendor.

Doug
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Auto download of Excel files in emails 4
Query from Access Database based on user selected parameters in Excel 2
Excel VB application 4
Download & Upload to Online Sheet 1
Reformat Excel Spreadsheet to List format 1
Query Data in Excel S/S from Access DB 2
Copying web pages onto Excel Spreadsheets using VBA 5

Back
Top