|
|
|
|
|
| | |
| |
Active Server Pages ASP programs help tutorial tutorials routine routines jobs listserve mailinglist bulletin board bulletin boards programming snippet snippets CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Automated Database Updates on WebServer |
|
From: |
Leo Creger |
|
Date: |
1/21/2001 4:56:12 PM |
|
IP: |
165.247.208.74 |
Subject : Automated Data Update Author : Leo Date : 01/21/2001 3:44:00 PM
I have a very large DB (85MB) on a webserver and I have a user that posts a .csv file (< 500K) to an FTP directory for a daily update of records on the website.
I have Access on my home machine that I do the testing. I have written a Macro that retrieves the .csv file, imports it into a table, then processes for adds (new records) and updates (existing records). I do this using 'Append' and 'Update' queries.
I am trying to automate this process on the web server with some type of auto schedule. It is a dedicated web server that I access remotely. OS is Win NT and I do not have MS Access on the Server. Can anyone offer a way to do this. I have the SQL statements for the queries but does not solve the interaction with the .csv file.
Any ideas would be appreciated.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
