Import large text file

[L. A. M.]

Hi,

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

Thanks

Luis

 

[David McRitchie]

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.

 

[Dave Peterson]

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.

 

[L. A. M.]

Thanks David, but I would like to use VBA code for this purpose.

Luis

 

[David McRitchie]

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.

 

[L. A. M.]

Ok David, thank you very much

Luis

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.

 

[L. A. M.]

Thanks Dave

Luis

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.