To copy one by one is one of the tedious job. So as suggested by others.. Use SQL Enterprise Manager to import your database to SQL server by which it can copy all your tables, queires and reports directly into it. Open SQL Enterprise manager, create new database as the name of the access dbase name, to view and click to import and select the database and you need to give the server name as the name given for SQL Server. after the you need to give path and after that it will ask you to copy tables, tables and queries and so on. After that you can copy the tables wihout any hindrance. Choose the dbase name that you gave earlier or created. Try this and it works.
sangay
|