Did you try to rename the file to .csv and the just open the file with excel?
a .csv file use the Excel icon. You can go to the window explorer and
double click on the .csv file and it willopen in excel.

"anto" wrote:

Hi Joel,
Yes, I am using 2007 - the problem is the Text Import only allows up to 65K
rows. I assume this function has not been upgraded from the 2003 version. Is
there a fix for this available to download?

"Joel" wrote:

I assume you are working with 2007 since 2003 has a limitation of only 65K
rows per worksheet. If the file is truly as csv file then rename tthe file
to .csv. Then opening the file in excel should give you all the data.

"anto" wrote:

I have tried to import a large text file by converting it to .CVS. While this
works to bring in all the records (350K rows) it imports the columns in such
a way that the Text to Edit is to complex needs a lot of manual work. I have
tried the Text Import which does work but this only brings in first 65K rows.
It seems the Text import wizard is has not been upgrade from 2003 version. Is
there a fix for this as I need this now?

Thanks, Anthony