LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default Text Import Wizard (use for large files)

I've got a text file that I am attempting to import (over 65500 lines) and of
course I'm getting the alert for the size limit for one worksheet. However,
Excel does prompt me with the following message. Can someone give me a quick
description of how to rerun the import on another tab and EXCLUDE the
previous data? I've attempted this but it seems to just import the same
data. I've looked in the options for some sort of setting, but have not
found anything useful.
Thanks in advance...

"The text file contains more data than will fit on a single worksheet.
To continue and import as much of the dta 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."
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text Import Wizard Duncan Help Excel Discussion (Misc queries) 1 July 27th 06 03:38 PM
Text Import Wizard: File Origin Problem Baldbloke Excel Discussion (Misc queries) 0 March 29th 06 02:51 PM
Excel Text Import Wizard [email protected] Excel Discussion (Misc queries) 2 September 12th 05 12:00 AM
multiple text files URGENT tasha Excel Discussion (Misc queries) 1 December 19th 04 05:44 PM
importing multiple text files??? tashayu Excel Discussion (Misc queries) 0 December 19th 04 02:43 PM


All times are GMT +1. The time now is 02:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"