[thelist] SQL Server: Can I Import an Access DB via HTTP?

Anthony Baratta Anthony at Baratta.com
Wed Sep 5 18:32:00 CDT 2001


My 2 Cents...

Option One

FTP the Access file from the hosting Web Server to the MS SQL Web Server 
via Cron/At and a VBS Script, then use DTS and the MS SQL Scheduler (or 
Cron/At and a VBS Script) to import the data.

Option Two

Use Cron/At and a VBS Script on the Access Hosting Web Server to open the 
Access File and a remote ADO Connection with the MS SQL Server and feed the 
data to the MS SQL Database.
----
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."





More information about the thelist mailing list