[SOLVED] Import large text file

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.
---
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 news:[email protected]...
> Hi,
>
> Which options do I have to import a text file to Excel, with more than
> 200.000 records.
>
> Thanks
>
> Luis
>
>

Microsoft has a macro solution that does something similar:
http://support.microsoft.com/default...;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." wrote:
>
> Hi,
>
> Which options do I have to import a text file to Excel, with more than
> 200.000 records.
>
> Thanks
>
> Luis

--

Dave Peterson

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

Luis

"David McRitchie" <[email protected]> escribió en el mensaje
news:[email protected]...
> 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
> news:[email protected]...
>> Hi,
>>
>> Which options do I have to import a text file to Excel, with more than
>> 200.000 records.
>>
>> Thanks
>>
>> 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.

---
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 news:[email protected]...
> Thanks David, but I would like to use VBA code for this purpose.
>
> Luis
>
> "David McRitchie" <[email protected]> escribió en el mensaje
> news:[email protected]...
> > 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
> > news:[email protected]...
> >> Hi,
> >>
> >> Which options do I have to import a text file to Excel, with more than
> >> 200.000 records.
> >>
> >> Thanks
> >>
> >> Luis
> >>
> >>
> >
> >
> >
>
>

Ok David, thank you very much

Luis
"David McRitchie" <[email protected]> escribió en el mensaje
news:%[email protected]...
> 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." <luism0(arroba)yahoo.es> wrote in message
> news:[email protected]...
>> Thanks David, but I would like to use VBA code for this purpose.
>>
>> Luis
>>
>> "David McRitchie" <[email protected]> escribió en el mensaje
>> news:[email protected]...
>> > 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
>> > news:[email protected]...
>> >> Hi,
>> >>
>> >> Which options do I have to import a text file to Excel, with more than
>> >> 200.000 records.
>> >>
>> >> Thanks
>> >>
>> >> Luis
>> >>
>> >>
>> >
>> >
>> >
>>
>>
>
>

Thanks Dave

Luis

"Dave Peterson" <[email protected]> escribió en el mensaje
news:[email protected]...
> Microsoft has a macro solution that does something similar:
> http://support.microsoft.com/default...;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." wrote:
>>
>> Hi,
>>
>> Which options do I have to import a text file to Excel, with more than
>> 200.000 records.
>>
>> Thanks
>>
>> Luis
>
> --
>
> Dave Peterson