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

Thread: Importing a Single Text file into multiple worksheets?

  1. #1
    New Member
    Join Date
    Nov 2009
    Location
    Raleigh, NC
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Importing a Single Text file into multiple worksheets?

    Is it possible to import a single text file into Excel, splitting the incoming data across multiple worksheets rather than a single worksheet? Each each row on the text file would be evaluated by the value in one of it's "columns" and written to the appropriate worksheet. The file is "!" delimited and has 11 columns for each row.

    Currently, I import the file into one worksheet and cut/paste the rows manually into new worksheets/tabs. The files are very large, sometimes exceeding the 65,536 row limit, which I could avoid if the data was split out coming in.

    Any help anyone could provide would be WONDERFUL. Thanks!

  2. #2
    Board Regular
    Join Date
    Feb 2003
    Location
    Luton, England.
    Posts
    8,127
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Importing a Single Text file into multiple worksheets?

    Hopefully my code here will help you get started - although it was written to answer another problem it should work.

    http://www.mrexcel.com/forum/showthread.php?p=761632

    However, your method does seem against the principle that it is best to keep data in a single table, when the powerful data functions etc. can be used. Personally I would put the data into an Access table. It is not too difficult to get to get Excel to use it from there, assuming Access itself is not better. In actual practice when using big files I generally do a lot of work in Access and then export to a .xls file for pretty formatting of reports.
    Regards
    BrianB (using XL2003 & 2010)
    www.cycleofgrowth.com
    Most problems occur from starting at the wrong place.
    Use a cup of coffee to speed up all Windows processes.
    It is easy until you know how.
    **FORMATTED/COMMENTED CODE IS MORE LIKELY TO GET A REPLY

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
  •