Import large text file

  • Thread starter Thread starter L. A. M.
  • Start date Start date
L

L. A. M.

Hi,

Which options do I have to import a text file to Excel, with more than
200.000 records.

Thanks

Luis
 
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.
 
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.
 
Ok David, thank you very much

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.
Click to expand...
 
Back
Top