David McRitchie said:Hi Luis,
Did you try opening the file from Excel (file,open)
then after going through the file import wizard and
you have what you want you can use file, save as, ...)
Since you are not used to this suggest you start with
a copy of your flat text file.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
L. A. M. said:Hi,
Which options do I have to import a text file to Excel, with more than
200.000 records.
Thanks
Luis
L. A. M. said:Thanks David, but I would like to use VBA code for this purpose.
Luis
David McRitchie said:Hi Luis,
Did you try opening the file from Excel (file,open)
then after going through the file import wizard and
you have what you want you can use file, save as, ...)
Since you are not used to this suggest you start with
a copy of your flat text file.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
L. A. M. said:Hi,
Which options do I have to import a text file to Excel, with more than
200.000 records.
Thanks
Luis
David McRitchie said:Thanks for telling me, then the other answer by Dave Peterson
referring to a Microsoft article probably has the answer you were
seeking. The best newsgroup for macro assistance
is microsoft.public.excel.programming then we also
know that you are prepared for a macro solution and know
how to install and use a macro besides.
Just glanced at it to make sure it used Long when referring to
rows instead of Integer. It actually uses Double -- don't know
why that was used but a Double floating point dimension would work.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
L. A. M. said:Thanks David, but I would like to use VBA code for this purpose.
Luis
David McRitchie said:Hi Luis,
Did you try opening the file from Excel (file,open)
then after going through the file import wizard and
you have what you want you can use file, save as, ...)
Since you are not used to this suggest you start with
a copy of your flat text file.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"L. A. M." <luism0(arroba)yahoo.es> wrote in message
Hi,
Which options do I have to import a text file to Excel, with more than
200.000 records.
Thanks
Luis
Dave Peterson said:Microsoft has a macro solution that does something similar:
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+)
I'd just use my favorite text editor and split the data into smaller
pieces--and
then import each piece to a new worksheet.