Can someone show me how to export tables and table data from Access into SQL Server database? In another words, how to duplicate the Access database into SQL Server. Thanks.
If you are using SQL Server 7.0 you can use the Data Transformation Services under Tools. It will take you through the whole process with a wizard.