Monday, September 25, 2006
Migrating data from MS Access to SQL Server is quite simple using the Windows Clipboard. Open the MS Access table and select all the rows. In SQL Server, remove any conflicting rows and disable the identity value generation for all columns, if you'd like to maintain the same ID numbers. Then, open the table, click on the left of the new row and paste!