[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
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."

More information about the thelist mailing list