[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