hi gurus,

i am working on a project where in i have 2 packages. One is an offline package which is a combination of VB and Access database. There are around 20 locations where this type of offline package is installed. All these places are not networked. Once in a while i.e.,once in 15 days or 1 month data from these places are uploaded to an internet server through Internet. In the Internet server a web application is hosted through ASP and SQL Server. The data from the offline package(Access database) has to be uploaded to SQL Server database. Data from 15 tables will be uploaded. The table schema of both the databases are similar. There might be 100 records in each table.


At present, we are uploading by creating 2 connections from VB code. One connection is to the Access database and another connection is to the SQL Server . (We know the IP address of the Server where SQL Server is present).

Which is the best way of uploading data from Access to SQL Server?