| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to export to a CSV but my file has more than 65536 rows | Excel Discussion (Misc queries) | |||
| How can I export text from excel autoshapes to a text file? | Excel Discussion (Misc queries) | |||
| opening text files that have more rows than 65536 | Excel Worksheet Functions | |||
| Export excel file to semicolon delimited text file | Excel Discussion (Misc queries) | |||
| How can I open a large Excel file with more than 65536 rows? | Excel Discussion (Misc queries) | |||
Linear Mode
