2. ASPRunnerPro General questions
  3. Downloading DB Daily
This topic is locked

Downloading DB Daily

 		2/18/2004 6:00:44 AM
ASPRunnerPro General questions
author

Is there a better way to do what I have been doing? I have an extensive website that employees go to to turn in the data they have gathered thoughout the day. I download the database from the internet daily so I can run the custom reports that are generated in Access. There can be a few as 30 reports that need to be run or as many as 200 and these are really divided in 10 main reports. I have looked at 4GuysFromRolly seeing if I could automate this process but that is complicated. I would like to have an Admin. page that allows me to state the dates I would like to run the report - which do have their own queries and have the report download automaticly when the button is clicked. I currently do have the reports exported to Word from Access and automated the email to the proper Account Manager's. Is it that I need to make a Word Template, select the query's criteria, create a temp table to hold that data, automate the export from Word to Access with a batch file of some sort, and just have it execute when clicked? I know there has to be a process that Amazon.com and the like use for orders versus doing what I am doing.
Thanks for all input <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=370&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
Sergey Kornilov admin 2/18/2004

Hi,
this looks like a job for small VB or MS Access application.
What is the result of the whole process. I guess you create some Word file(s) and send them by email. Is that correct?
501009 2/19/2004

You are correct. Any suggestions on how to go about it?
Thanks
Sergey Kornilov admin 2/19/2004

Well, here is what I would do for this purpose:

  1. Write a batch file that downloads MS Access databases nightly
    ftp.exe ftp.someserver.com

    username

    password

    cd database

    get database1.mdb

    get database2.mdb

    ...

    close

    bye


2. Develop several SQL queries in MS Access that prepares data, calculate totals etc.
3. Use MS Word mail merge feature to create Word file(s) automatically using queries in MS Access as a datasource. Personally I would prefer to have reports in HTML can be send by email or published on the Web. I would use DBtoHTML Express for this purpose.
4. Upload reports to the Web site or send it by email using any program that can do it automatically. Simple VB script can send emails using CDONTS object.
That's it.