LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default splitting a file into two before importing it to excel

Hi all,
Just wonder anyone could advise of any code to split a file into two
before importing the files into excel....this is because the file data
has exceeded the limitation of excel(too many lines). I am looking for a
way to split a file into two(one with 30000 line of data) while the
other with the rest of the lines of data before importing them to excel.
Thanks in advance.
 
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 txt file into Excel - Bill K Excel Discussion (Misc queries) 1 February 8th 10 07:24 AM
Importing VBA file into Excel Brian Service Excel Programming 0 November 19th 07 02:25 PM
Splitting Excel file into many workbooks [email protected] Excel Programming 5 June 28th 07 03:56 PM
Importing and splitting large text file JeffMelton Excel Programming 1 August 29th 06 12:29 AM
importing a csv file into Excel JenC Excel Programming 1 February 14th 06 04:58 PM


All times are GMT +1. The time now is 07:17 PM.

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"