Re: Use ASP/SQL to export to Excel?

by Doug Miles <douglas_miles(at)yahoo.com>

Date:	Tue, 17 Apr 2001 13:16:31 -0500
To:	Mike Taylor <lonewolf(at)one.net>, hwg-techniques(at)hwg.org
In-Reply-To:	one
	todo: View Thread, Original

If you have Office 2000 installed on your server, you can generate excel 
files from ASP using the Office Web Component.  4GuysFromRolla had a 3-part 
write up on the technique:
http://www.4guysfromrolla.com/webtech/022801-1.shtml

HTH,
--Doug

At 10:53 AM 4/17/2001 -0400, Mike Taylor wrote:
>I have an ASP page written in VBScript I've put together for some in-house
>reps to display data from a SQL database.  This data is generated on the
>page in, of course, HTML format.  I've gotten requests about clicking on a
>link that will generate the same info in Excel format.
>
>The only way I know of to do this would be to run a SQL job that exports
>to that format, but I see no way of triggering that from the client's
>machine.
>
>Is there another way to do this?
>
>Thanks,
>Mike Taylor

_________________________________________________________
Do You Yahoo!?
Get your free (at)yahoo.com address at http://mail.yahoo.com

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA