From: chen li <chen_li3@...>
Date: 2006-12-16T01:39:41+09:00
Subject: Re: Importing from text file to Excel


--- anon1m0us <anon1m0us@yahoo.com> wrote:

> Hi;
> Below is my code to import from a text file to
> EXCEL. I am encountering
> a few issues.
> 1) the import file is larger than 65,536 which is
> the max Excel can
> have as an input. The file is broken in to two
> files. However, I would
> like to create files based on the alphabit. For
> example, All last name
> from A-J is in one file, and the file should be
> names A-J. The second
> should be from J-W and thrid X-Z.

Use regular expression to get your data into (an)
array(s), sort them, then import into excel

Li 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com