The first noteworhty piece of real estate they destroyed was edwards air force base. and to this very day, wing-nuts and data reduction clerks alike speak in reverent whispers about that fateful T when test stand number one and the rocket sled itself got lunched, I said lunched, by a famous mountain and his small wooden wife ...
I believe Access is an upsizing wizard that you can use. You could use SQL Server to do the conversion via SSIS or DTS (depends on SQL version). I believe most people just upsize though.