Right now I read mdb to datasetAre you doing this in Access, or in .NET? A "Dataset" is specific to .NET, but it could also be used to describe other items.
I read mdb to dataset and insert to sql table using insert bulk.
Can you show how you're doing that? I'm curious how you read from one connection and insert into another in bulk.
Using code to process records will always be slower than doing it with SQL statements (a query in Access).
Also I would review the indexing that is being used on the Access tables.
Jim.