Thread: How big can files be to import to excel, and is there a rec limit?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FastLiveHelp
 
Posts: n/a
Default How big can files be to import to excel, and is there a rec limit?

Hello,

The worksheet limits on Excel a 65,536 rows by 256 columns.

If your csv has more than 65,536 lines of text in it that is most
likely your problem.

You could either get a program to split your file into chunks or do it
with an Excel macro and then import the chunks into separate
worksheets.


--
FastLiveHelp

Database, website, and application developer
------------------------------------------------------------------------
FastLiveHelp's Profile: http://www.excelforum.com/member.php...o&userid=31779
View this thread: http://www.excelforum.com/showthread...hreadid=515165

Reply With QuoteReply With Quote