Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Basics
| Search | Today's Posts | Mark Forums Read
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old July 9th, 2006, 10:01 AM
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
  #2 (permalink)  
Old July 16th, 2006, 05:25 AM
Friend of Wrox
Join Date: Jun 2003
Location: High Wycombe, UK, United Kingdom.
Posts: 344
Thanks: 0
Thanked 1 Time in 1 Post

check out http://www.greggriffiths.org/webdev/both/excel/ which contains some methods of doing this, I guess the ActiveX one is probably closest to what you would need, although you will have to add a lot more VBA code that the example shows to get your solution to work.

Similar Threads
Thread Thread Starter Forum Replies Last Post
export to Excel and Page breaks sifuuu Crystal Reports 0 March 21st, 2007 06:42 AM
Export Access queries to Excel Spymaster Access VBA 2 August 18th, 2006 11:21 AM
Export an Access query to Excel Peter Martin Access 5 June 8th, 2006 06:36 AM
Export Access Paramter Query to Excel jcharlton VB Databases Basics 1 February 10th, 2006 08:58 AM
Export Table from Access to Excel aramchan Access VBA 2 July 12th, 2004 03:20 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.