Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  About many to many tables in DTS

Author  Topic  hegdes Starting Member 1 Post Posted - 2004-10-15 : 04:55:55 Hi, I want to transform data from MS Access to SQL Server 2000. The Source and destination tables won't match and I have the mappings done for that. I have a requirement of moving data from 2-3 tables of MS Access into 3-4 tables of SQL Server. How can I do it using SQL Server? Thanx in advance, Regards, Hegde.