I need to take the records from my MS Access DB and migrate them to SQL 2000

I need to take the records from my MS Access DB and migrate them to SQL. I have both db table structures somewhat mapped out and its only about 43 records or lines. The data in Access is all kept in a single table and in SQL I need to have it populate seperate individual tables.

I've successfully imported and exported data in SQL by doing simple DTS and queries. With this transfer I don't know how to write the correct query or statement.

Try the links below for options because Microsoft bought a migration tool company you can test drive it or use ready DTS packages from the second link. Hope this helps.
http://www.microsoft.com/sql/migration/default.mspx

http://www.sqldts.com/?220