Importing text files larger than 65536 rows into excel

[A D]

I need to import a spreadsheet with many more lines than excel allows..

I have found this but unsure how to set it up.

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

Anyone know anything about macros in excel?

If you can help on msn i would be most appreacaitive.

msn id: [email protected]

-=DCG=-

 

[dodo1]

Hi Adam,

Excel 2007 supports more than 1,000,000 rows. You can download MS Office 2007 Beta 2 from Microsoft's website:

http://www.microsoft.com/office/preview/beta/getthebeta.mspx

I have been using Office 2007 about three weeks now without having any problems. It seems quite stable.

In case you do not want to download or order Excel 2007, I do not know any other program supporting more rows than Excel, but your current version should support 65,536 rows per sheet. So you can also put as many sheets into your Excel file as you need.

 

[Dale Hubbard]

http://www.freedownloadscenter.com/Best/free-split-exe.html

Choose a free splitter. Rename split files accordingly, then import into sheets. No macros or upgrade needed. If you can't find a good splitter, I have one.

 

[RatherGood]

I use "CSVed" for CSV/Text files larger than 65536 rows. Its free and does everything you wish excel would do.

http://home.hccnet.nl/s.j.francke/software/software.htm

 

[A D]

All great solutions,

Thanks to all, I got it working great!

-=DCG=-