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
Re: How to: Handle CSV files > 1mill rows
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?
Re: How to: Handle CSV files > 1mill rows
Hi,
do have any code??? seesm a little confusing