LLBLGen 3.0 8/18/2010

I have a ACCESS database containing sales data that I need to get into an SQL database. Some of the tables have 800,00 records in them. I have a LLBLgen project for each of the databases. The table layout is identical for both. I can create a collection from the ACCESS database for the table that I want to move and read each record and save it to the SQL database. This doesn't seam to be the best way to do this. Would take to long.

Can you point me in the right direction or tell me the most iffecient way to do this? Can I do an insert into from query? Any help would be greatly appreciated.

As ever, tools have their uses - and this is not the best one for LLBLGen - the quantities of data involved will make it slow.

Have a look at SQL integration services - it's designed for exactly this sort of thing.

Matt