What's "huge"? Access is limited to (I think) around 1 GB.
Originally Posted by akrupak
If you have a licensed copy of SQL Server, you can use the database upsizing wizard (though I don't necessarily recommend this). It might be the simplest and quickest route, but you will learn very little about SQL Server in the process.
If you don't have a licensed copy of SQL Server, you should still be eligible for MSDE 2000 (since you have a licensed copy of MS Access).
You could also use a DTS package, but again you will learn very little in the process.
Some things to watch out for:
Converting Access Date/Time to SQL datetime. The wizards usually choose the smaller SQL data type smalldatetime. You will lose some precision in the conversion.
Converting Access Yes/No data type to SQL bit data type. SQL bit is 0/1 while Access is 0/-1.
Often times when converting an Access Query, the wizards will simply take the data in a query and create a new table in SQL. Usually this is not what you want. Usually you will want to create an MS SQL View.
Practice the conversion process several times in a development environment before you go for the actual thing. Make sure you have a backout plan before starting the final conversion. Make sure you have good backups of the Access database before you touch anything.
Have you hugged your backup today?