Database Discussion - write to .xls file each day...

Print Page | Close Window

write to .xls file each day...

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=4322
Printed Date: 29 March 2026 at 6:02am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: write to .xls file each day...

Posted By: KCWebMonkey
Subject: write to .xls file each day...
Date Posted: 18 July 2003 at 10:41am

I have a few columns in a db that i want written to an .xls file each day at a certain time. can anyone get me started on how do do this?

Replies:

Posted By: michael
Date Posted: 18 July 2003 at 11:28am

Here is a tutorial I have used before and works alright. You just need to have the Office Web Extensions installed.

http://www.serverwatch.com/tutorials/article.php/1493331 - http://www.serverwatch.com/tutorials/article.php/1493331

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: KCWebMonkey
Date Posted: 18 July 2003 at 12:08pm

I guess i don't have the Office Web Extensions installed because i get the following error:

Microsoft VBScript runtime error '800a01ad'

ActiveX component can't create object: 'Excel.Sheet'

Do you know if there is another way to do it? I don't think that i can get the Office Web Extensions installed (it's like pulling teeth to get them to do anything...).

Posted By: Flamewave
Date Posted: 18 July 2003 at 2:34pm

This may be of some help, I had to create something similar to what you are doing, only it would create a report only every time the admin would visit the page.

Link: http://www.aspalliance.com/stevesmith/articles/exceltutorial.asp - http://www.aspalliance.com/stevesmith/articles/exceltutorial.asp

-------------
- Flamewave

They say the grass is greener on the other side, but if you really think about it, the grass is greener on both sides.

Posted By: faubo
Date Posted: 18 July 2003 at 3:46pm

Great tips!

not sure when it will use it, but great anyway!

-------------
http://www.conhecerparaconservar.org - I don't know how to make you click here