We are using a simple C# program to cleanup and then import 100,000 records into a access table.
Import time is pathetic, takes over 10 minutes, the same data into sql server takes 1:45.
we are using oledb, and run a simple insert into.
we basically open the database, create a sgl cmd, prepare...