Excel

J

Juan

I'm trying to import a large file into
excell. It seems not to care on the length of the
record but it only
loads 65536 records and gives me the edit message that it
didn't load the
whole file. Is there an easy way to get this file into
2 or more parts
at a specific beginning of a record that you know of?
 
D

Dave Peterson

I really like the idea of using my favorite text editor to split the text file
into smaller pieces. (then import them separately.)

But if you hate it, you could use a macro that imports each line:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q120596
XL: Importing Text Files Larger Than 16384 Rows
(written for xl95, but has a note to change stuff for xl97+)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

======
And I'm not sure what the limit is for line length for importing text files, but
excel won't support more than 256 fields/columns.
 
Top