+ Reply to Thread
Results 1 to 6 of 6

Import big text file into multiple sheets

  1. #1
    Forum Contributor
    Join Date
    01-18-2005
    Posts
    238

    Import big text file into multiple sheets

    I am trying to import a text file into excel.

    Right before the import takes place, I get a dialog box that states:

    the text file contains more data than will fit on a single worksheet.

    To continue and import as much of the data as will fit, click ok. You can then import the rest of the data by repeating the import operation on another worksheet and using the text import wizard to exclude data already imported.


    Is there anyway to code this with doing this automatically into the next sheet?


    thanks for any help

    Josh

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202
    Here's some code

    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Contributor
    Join Date
    01-18-2005
    Posts
    238

    Thanks roy

    Thank you kindly for the help!

    Josh

  4. #4
    Registered User
    Join Date
    10-08-2015
    Location
    Houston
    MS-Off Ver
    2013
    Posts
    1

    Re: Import big text file into multiple sheets

    So I am a total novice and I think the code that you have posted will help me but what steps do I take before entering the code?

    Again, I am a basic user.

    Thank you!

  5. #5
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,315

    Re: Import big text file into multiple sheets

    Here are some instructions

    http://www.rondebruin.nl/win/code.htm

    you will want to insert a module and paste it in there.

    then alt F8 brings up the menu you can use to see the macro you have inserted.

  6. #6
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,981

    Re: Import big text file into multiple sheets

    linspalmer,
    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1