export a text file which more than 65536 rows into excel
 

guys i wanna export a text file which more than 65536 rows
into excel
excel has limation of transferring data to excel to 65536
now how do i handle rows more than 65536 if wanna export it to excel
i need to create extra spreadheets and export into it.
so do i go abt it...
i wanna do it way the fastest.
can you show me macro where by i can export all my data into excel and
create new sheets on the fly.

export a text file which more than 65536 rows into excel
 

What is the source of the data? In the vb.general.discussion group you
said the source was a 'table'. The reason I ask is that the faster
approach would be to use the RDBMS and ADO rather than a text file. If
the source is a RDBMS, please say which one.

(Navin) wrote in message . com...
guys i wanna export a text file which more than 65536 rows
into excel
excel has limation of transferring data to excel to 65536
now how do i handle rows more than 65536 if wanna export it to excel
i need to create extra spreadheets and export into it.
so do i go abt it...
i wanna do it way the fastest.
can you show me macro where by i can export all my data into excel and
create new sheets on the fly.

export a text file which more than 65536 rows into excel
 

http://www.google.com/groups?hl=en&l...GP09.ph x.gbl


--

John

johnf202 at hotmail dot com


"Navin" wrote in message om...
guys i wanna export a text file which more than 65536 rows
into excel
excel has limation of transferring data to excel to 65536
now how do i handle rows more than 65536 if wanna export it to excel
i need to create extra spreadheets and export into it.
so do i go abt it...
i wanna do it way the fastest.
can you show me macro where by i can export all my data into excel and
create new sheets on the fly.