Mark A Matte
markamatte at hotmail.com
Fri Mar 14 10:09:46 CDT 2008
Hello All, I currently have an MDB that does the following: 1. Checks FTP site to see if there are files.(does not know name of files) CONTINUE checking until there are files 2. Get FTP files. 3. Unzips FTP files. 4. Imports file. 5. Runs SQL stored in tables against new data. 6. Saves/emails results of SQL. 7. Cleans up and waits for 30 minutes. This works like a charm in Access...I plan on moving to SQL Server, creating a site to go with it and have it hosted. I need this thing to run every 30 minutes. Its been suggested that I use VB scripts since I am so familiar with VBA. I'm a little confused on the approach. Q1. Are these 6 different scripts...1 large script...some scripts...some SP? Q2. How do I launch/manage these tasks? They all have to run...but in order. Q3. If multiple Scripts and SP...how does 1 know the other is done? ...there are more questions...but this is more than enough for me to chew right now. I'm not really looking for code (would be nice if it landed in my inbox)...but more for suggested approaches and direction. Any thoughts/ideas/guidence? Thanks, Mark A. Matte _________________________________________________________________ Shed those extra pounds with MSN and The Biggest Loser! http://biggestloser.msn.com/