export a text file which more than 65536 rows into excel

N

Navin

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.
 
O

onedaywhen

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export a text file which more than 65536 rows 1
Split a text file with more than 65536 lines over many worksheets 4
Excel 2007 - ADO - More than 65536 rows - Problem ? 7
Splitting data on sheets for more than 65536 rows... 1
data with more than 65536 lines 2
Importing Text File with more than 65536 rows 4
Reading in text file that is more than 65536 rows 2
how do I import a CSV file with more than 65536 rows 9

Top