Reading data from access 97 into Sql

Question

Hi all What is the best method to move data from an access database into sql server database with different table and field names? If possible could you give me an example? Thank you so much!

Master Billa · Answer

Hi Yes you can use the import/export tool in sql server this very easy and faster way to do this to data migration http://www.databasejournal.com/features/mssql/article.php/3580216/SQL-Server-2005-Import--Export-Wizard.htm thank you