Using ODBC to insert a record at a time will be painful. The approach you nned to take is to leverage the programability of Access itself. You should be able to find ways to utilize Access' import wizard functionality via script. The result should be import speeds the same as interactive Access use.
I did not find any quick access to the importWizard although I did see some references.
Using ADO may be faster: How Can I Import a .CSV File into an Access Database?
