On Tue, 20 Sep 2005 08:54:01 -0700, Larry Liu <Larry
wrote:

I have a csv file that I try to import into Excel and the number of rows is
larger thatn 65536. The Excel 2000 seemed to be only capable of loading 65536
rows. Is there a way to overcome this ?

If you must load the data into Excel, you will have to either load only a
sample of your data (e.g. every tenth record); or use multiple worksheets.

Both of those solutions require VBA programming.

If this is a large DB, you should look for a different solution (e.g. Microsoft
Access).


--ron