How to: Handle CSV files > 1mill rows

Hi,
I've regular data that is in csv format and always more than 1 million row. I normally upload the data to access, then correct the data ( as some rows have repeated column headings) and run query the data and copy-paste to different excel files.

Is there any other cleaner way as it takes a lot of time and shows the limitation of excel bluntly.

regards
Satti, Charvak

open a recordset in access (full)
open excel automation
open/add new workbok
start outputting the data to the sheet, count each row.
When you get to 65000, create a new sheet and continue.
Repeat until all data exported.

Is there a reason you want it in excel?

Hi,
do have any code??? seesm a little confusing