Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Importing LARGE text files

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I want to import _parts_ of a huge .csv
    file. The files is about 200,000 rows of data.

    When I use the text file importer, and I enter a "start row" of 100,000 lets say, it doesnt allow the value and says "not a valid integer".

    I guess this would be easy if I had a utility to split the 1 huge file up into segments of 65,000. But what utility would I use?

    Thanks for any help.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Sadly you cant CSV 200000 to ^%536 dont go Excel wont like it, if over ODBC and so skip CVS save as then span sheets else... copy and paste in to more than one sheet..

    BTW IBM Lotus 123 have 1,000,000 ROWS.. but not convertable to Excel.. too many rows...

    No FIX:

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    Integers only go up to about 37,000 or so.
    I guess that is what the problem is???
    Can import easily with code, but a lot slower perhaps.
    Post a few of your lines from the file and tell how you want it formatted and arranged on yout sheets....
    Or E-Mail...
    I like this kind of stuff.
    TsTom@hotmail.com
    Have a Nice Day!
    Tom

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-02 12:53, TsTom wrote:
    Hi
    Integers only go up to about 37,000 or so.
    I guess that is what the problem is???
    Can import easily with code, but a lot slower perhaps.
    Post a few of your lines from the file and tell how you want it formatted and arranged on yout sheets....
    Or E-Mail...
    I like this kind of stuff.
    TsTom@hotmail.com
    Have a Nice Day!
    Tom
    If you really would like to do it I will email you a small sample of the data. I would post it here, but its 11 columns wide and hard to fit into this message board format.

    Thanks alot!




  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Please email me the solution im fed up of no real fix to this.. or a good fix i add,,

    cherrs mte

    JackintheUK
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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