You should be able to do so via 1) ODBC 2) named pipes 3) TCP/IP There is (used to be, anyway) an Access "Upsizing Wizard" that would create a SQL Server db from an .mdb ... As long as you don't have too many Access-specific SQL queries/statements (from recollection) Otherwise, you will have to write some SQL CREATE TABLE scripts and import the data. BCP (BulkCopy) is a command line interface that uses either netbeui or TCP/IP to connect to the SQL Server db. Far and away the easiest is ODBC -- some overhead; but if you're looking for ease of use, it's probably it. It's located in the Windows Control Panel. You specify the DSN, db, privs, etc. and then link your Access tables to the MS SQL Server and copy away. -- Carl ----- Original Message ----- From: James Aylard To: Evolt Sent: Wednesday, September 05, 2001 6:15 PM Subject: [thelist] SQL Server: Can I Import an Access DB via HTTP? SQL Server types: On a far-flung branch of the corporate Intranet is an Access database that I would like to periodically -- and automatically -- import into a SQL server table. I can access the MDB file via a URL, but not via the file system, and the hurdles I would have to jump over to gain access to the file through the file system are too horrendous to even ponder. My question: is it possible to import data from an MDB file via HTTP rather than via the file system? I can't find any info on this either at microsoft.com or via google, so I'm turning to the big guns for help... Anyone? James Aylard --------------------------------------- For unsubscribe and other options, including the Tip Harvester and archive of TheList go to: http://lists.evolt.org Workers of the Web, evolt !