Classic ASP Discussion - update from Access to SQL

Print Page | Close Window

update from Access to SQL

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=14398
Printed Date: 30 March 2026 at 11:29am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: update from Access to SQL

Posted By: zMaestro
Subject: update from Access to SQL
Date Posted: 24 March 2005 at 3:33am

Hi,

Is there an easy way to update from access to sql?

I've a situation where a cient is using on his local Intranet an access database, and he connects once per day to upload his work to the internet, Is there a way to update the online SQL database with the new records just added daily?

Thanks

Replies:

Posted By: michael
Date Posted: 24 March 2005 at 5:37pm

Schedule a DTS bulk insert task. It would require SQL to be installed locally also, if that is not an option you can write a simple script to do that on a schedule.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker