I am trying to insert data from an SQL database to an access database. I know that I need 2 connections, but after that I am lost. Any help in getting started is appreciated.
Why not link to the SQL Server tables within the Access database. Then you can run Insert,Apend,Delete & Select queries on the data and only need one connection.
I've tried that, but the linked SQL db requires a username and password. I have not been able to connect to the linked table with asp. How can I give that information via asp?