I am trying to import data between an Access datacase and a SQL database. The problem is that the SQL database has two tables that have an ID field that the Access database does not. These fields are increased incrementaly by one as data is added to the SQL database, However I have to import data from the Access data base to the SQL database and I have to manually insert a column with a insert seed value on a temp database on each table before I insert the data into the SQL database. Is there a way to transfer data from the Access database into the SQL database where each record being inserted into the SQL database in the ID field is increased by 1 based on the last value from the previous record. [sig][/sig]
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL 7.0 DTS from Access
- Thread starter Marinus
- Start date
Similar threads
- Locked
- Question
