| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import tab text data(more than 65K rows) into excel by VBA
I would like to import tab determined text data into excel, but I have
to handle more than 65K rows. Colum is determined 47. How can I make VBA? Please give me some advices. Regards, Shinchan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Import tab text data(more than 65K rows) into excel by VBA
There are a number of options:
1. Don't use Excel, but instead Access. 2. Use File I/O and take chunks of the file and put in different sheets. 3. Download the Office 2007 beta: http://www.microsoft.com/office/prev...n/default.mspx Excel 2007 has 1048576 rows (2 ^ 20) compared to now 65536 (2 ^ 16) rows. RBS wrote in message oups.com... I would like to import tab determined text data into excel, but I have to handle more than 65K rows. Colum is determined 47. How can I make VBA? Please give me some advices. Regards, Shinchan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Import tab text data(more than 65K rows) into excel by VBA
Maybe you could use the code found here..........
http://support.microsoft.com/default...;en-us;Q120596 Gord Dibben MS Excel MVP On 30 Jun 2006 21:11:28 -0700, wrote: I would like to import tab determined text data into excel, but I have to handle more than 65K rows. Colum is determined 47. How can I make VBA? Please give me some advices. Regards, Shinchan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
| import text and sort data into excel | Excel Worksheet Functions | |||
| how to Import data in excel office2003 with data more 65000 rows | Excel Worksheet Functions | |||
| How do I import data into Excel that exceeds 70000 rows? | Excel Discussion (Misc queries) | |||
| how to import data from text file which has more 70k rows ? | Excel Programming | |||
Hybrid Mode
