What is the largest file size, I can Import to excel?

[Goran]

I have tryed to import a txt file (about 50MB) into excel and I recived
error message. Something about 65000 lines or so....

Any idea?

thanx
/goran

 

[Chip Pearson]

Goran,

The maximum number of rows on a worksheet is 65,536 so you can't
import more than that many records without writing code to work
with multiple worksheets.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[JE McGimpsey]

Each XL worksheet is limited to 65536 lines. For workarounds, see

http://support.microsoft.com/default.aspx?scid=kb;en-us;120596

or search the newsgroup archives:

http://google.com/advanced_group_search?q=group:*excel*


Also note Dana DeLouis' method to import up to 98,304 lines without a
macro:

http://google.com/groups?threadm=uueq5FZsAHA.2112@tkmsftngp05