How big can files be to import to excel, and is there a rec limit?
 

I am having problems importing a very large .csv file into excel and keep
getting an error message saying that the file is too big. What's up with that?

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

How big can files be to import to excel, and is there a rec limit?
 

There are 256 columns and 65536 rows in any excel worksheet.

How many lines/fields are in your .csv file?


MHayashisan wrote:

I am having problems importing a very large .csv file into excel and keep
getting an error message saying that the file is too big. What's up with that?

--

Dave Peterson

How big can files be to import to excel, and is there a rec limit?
 

from a previous post by Norman Jones

http://support.microsoft.com/?kbid=272729

"MHayashisan" wrote:

I am having problems importing a very large .csv file into excel and keep
getting an error message saying that the file is too big. What's up with that?