[thelist] Form data to office database

Joel D Canfield joel at streamliine.com
Thu Oct 11 09:08:55 CDT 2007

> How to create the files from the form data and put it in a 
> folder for ftp download?

Since it's on a Windows box, you should be able to use VBScript's
FileSystemObject [1] and write the contents of the form to a CSV file,
appending new items to an existing file or creating a new file for each

The simplest automated ftp download I've come up with is a DOS script,
but I'm sure there are other options.

If you use a single file, appending new entries, you have to create a
way to determine what's new data each time you download it. Depending on
how often the client wants to grab the data, you can collect it by hour,
day, week, whatever time period makes sense.

> Hosting is now on Win 2000 (old site), while I am used to 
> linux. What  
> are the consequences in this case? Or should we ask to move to linux  
> for the new site?

You can do what you're attempting on either. This need, by itself, isn't
reason to switch.


[1] This is classic ASP; if you need to use .NET, I don't know

More information about the thelist mailing list