Results 1 to 3 of 3

Thread: How to: Handle CSV files > 1mill rows

  1. Dec 14th, 2005, 02:06 AM #1
    satti charvak
    satti charvak is offline

    Thread Starter
    Lively Member satti charvak's Avatar
    Join Date
    Apr 2001
    Location
    noida, india
    Posts
    90

    Unhappy 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
    Reply With Quote Reply With Quote
  2. Dec 14th, 2005, 06:19 AM #2
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    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?

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
  3. Dec 16th, 2005, 06:20 AM #3
    satti charvak
    satti charvak is offline

    Thread Starter
    Lively Member satti charvak's Avatar
    Join Date
    Apr 2001
    Location
    noida, india
    Posts
    90

    Smile Re: How to: Handle CSV files > 1mill rows

    Hi,
    do have any code??? seesm a little confusing
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width