View Single Post
Old July 9th, 2006, 10:01 AM
u0107 u0107 is offline
Registered User
Join Date: Jul 2006
Location: Boise, ID, USA.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to u0107 Send a message via Yahoo to u0107
Default Export from Access to Excel in ASP generated page


I am a newbie to this forum but not such a newbie to Classic ASP.

I have a problem for which I have googled the net but have not found a satisfactory solution.

My website consists of a Back-end MS Access Database. The front end consists of ASP generated HTML and Javascript based code.

I am required to allow downloads of selected data from tables into an excel spreadsheet. What I am planning is to have a template-like (but NOT AN actual Excel Template) spreadsheet which will consist of standard worksheets in the workbook. One worksheet will be "Summary". Another will be "Charts" and so on. One worksheet will be "Raw Data".

Into the Raw Data worksheet should go my downloaded data. And since the downloaded data will be created by means of pre-formatted Query on Access Table or Tables, the column-wise content in that worksheet will be standard and pre-determined.

One other issue to keep in mind is that I would like that pre-existing "Names" (created by Insert-Name-Define in Excel) in my pre-formatted Excel Template-like workbook should not be clobbered or overwritten. (I do have a workaround for this by running a standard VBA in the Excel workbook to pre-define the names but it would be an overhead which I would like to avoid if I can.)

Thank you in advance.


Cultivate modesty in the midst of good fortune,
But in times of adversity preserve your dignity.

-Tirukkural 97:963