Welcome to the group!!!! This a great place to find information and help.
I think the best way to do the conversion is using DTS (SSIS in 2005) Which will create your tables and import that data for you. There will be some things you will need to tweak, but Access and SQL speak to each other very well. Refere to Books-On-Line (BOL) to understand how it is done. If you have any problems come back and ask.
The answers are pretty much quick enough to cover your time lines. Good luck and welcome again!!