I want to transfer data from MS Access to MS SQL Server7.0 . I have created tables using ASP. How to transfer data? Can I use the DTS from inside an ASP page? I have failed to connect to the SQL server remotely. I have data on local server in Access. I want to transfer it to Remote SQL Server over internet . I have the loginid/password etc to SQL database also.