Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Importing and splitting large text file

I remember finding a macro that would fit a text file into excel by
creating new sheets after 65.5k, but I've lost it. Does anybody have
something that can do this for me? Thanks

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,290
Default Importing and splitting large text file

http://support.microsoft.com/kb/120596/en-us
"Importing Text Files Larger Than 65536 Rows"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"JeffMelton"
wrote in message
I remember finding a macro that would fit a text file into excel by
creating new sheets after 65.5k, but I've lost it. Does anybody have
something that can do this for me? Thanks

Reply
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
Importing a large file hmm Excel Discussion (Misc queries) 1 August 2nd 06 12:29 PM
Importing large file Brian Matlack[_67_] Excel Programming 1 April 26th 06 08:47 AM
Importing a large text file hmm Excel Discussion (Misc queries) 4 March 15th 06 03:13 PM
Excel 2003 Importing large delimited text file Ron[_28_] Excel Programming 2 January 5th 05 02:58 PM
Importing a large text file (65536) Chip Pearson Excel Programming 0 May 18th 04 09:24 PM


All times are GMT +1. The time now is 09:08 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"