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!