[AccessD] New database from hell

JC,

You might be able to speed up the import dramatically by using bcp (the
bulk copy utility that comes with SQL Server). I have used it to import
many millions of rows and it's lightning-fast, compared to other tools.

A quick look in BOL should give you everything you need to know.
HTH,
A.