|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components 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.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
