Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Row Limitation - Import External Data
Hi All,
I am having a Text (.txt) file . It contains a record like this: CalledNo CalledDuration Date 12354 04:50 10/10/2005 4789 12:30 12/25/2005 .....etc. that Text file contains more than 80,000 records. how can i import that data from TEXT to EXCEL. Thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Row Limitation - Import External Data
You won't be able to put all the data on one sheet if you keep it in a single
block of three columns. Easiest thing to do is break the text file into pieces less than 65536 lines long and import to separate sheets. This is fairly easy to do in VBA. Let me know if you'd like more details. bp "Avadivelan TCS" wrote: Hi All, I am having a Text (.txt) file . It contains a record like this: CalledNo CalledDuration Date 12354 04:50 10/10/2005 4789 12:30 12/25/2005 ....etc. that Text file contains more than 80,000 records. how can i import that data from TEXT to EXCEL. Thanks in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Row Limitation - Import External Data
The only way in Excel 2003 would be to import to multiple tabs. e.g. 40,000
records on one tab and 40,000 on another. The easiest way to do this is to first import your data into Access. Then import your Access database into Excel: <Data <Import External Data <New Database Query Choose "MS Access Database" Then, from within the import wizard you can filter which records to import. You can, for example, do 1 import filtering all "CalledNo" < 40000... then do a second import filtering all "CalledNo" =40000. -- Regards, Dave "Avadivelan TCS" wrote: Hi All, I am having a Text (.txt) file . It contains a record like this: CalledNo CalledDuration Date 12354 04:50 10/10/2005 4789 12:30 12/25/2005 ....etc. that Text file contains more than 80,000 records. how can i import that data from TEXT to EXCEL. Thanks in advance |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Row Limitation - Import External Data
Hi Bill Pfister,
Ya i need more details, Is there any macro for automatically fill the data upto 65536 row in the Sheet1 and the remaining data in the Sheet2 "Bill Pfister" wrote: You won't be able to put all the data on one sheet if you keep it in a single block of three columns. Easiest thing to do is break the text file into pieces less than 65536 lines long and import to separate sheets. This is fairly easy to do in VBA. Let me know if you'd like more details. bp "Avadivelan TCS" wrote: Hi All, I am having a Text (.txt) file . It contains a record like this: CalledNo CalledDuration Date 12354 04:50 10/10/2005 4789 12:30 12/25/2005 ....etc. that Text file contains more than 80,000 records. how can i import that data from TEXT to EXCEL. Thanks in advance |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Row Limitation - Import External Data
You can either use Dave's suggestion to use Access an intermediate step or
you can write code that manually reads the textfile line-by-line and pastes to the appropriate sheet. If you do not have much programming experience, I would recommend Dave's suggestion. "Avadivelan TCS" wrote: Hi Bill Pfister, Ya i need more details, Is there any macro for automatically fill the data upto 65536 row in the Sheet1 and the remaining data in the Sheet2 "Bill Pfister" wrote: You won't be able to put all the data on one sheet if you keep it in a single block of three columns. Easiest thing to do is break the text file into pieces less than 65536 lines long and import to separate sheets. This is fairly easy to do in VBA. Let me know if you'd like more details. bp "Avadivelan TCS" wrote: Hi All, I am having a Text (.txt) file . It contains a record like this: CalledNo CalledDuration Date 12354 04:50 10/10/2005 4789 12:30 12/25/2005 ....etc. that Text file contains more than 80,000 records. how can i import that data from TEXT to EXCEL. Thanks in advance |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Row Limitation - Import External Data
Avadivelan TCS wrote:
Ya i need more details, Is there any macro for automatically fill the data upto 65536 row in the Sheet1 and the remaining data in the Sheet2 Here is the macro to do what you need. Importing text files larger than 65536 rows http://support.microsoft.com/kb/q120596/ Cheerz, Denzil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to do Edit Query from Import External Data. | Excel Discussion (Misc queries) | |||
How do i refresh external data import in excel in seconds | New Users to Excel | |||
Get External Data in Excel | Excel Discussion (Misc queries) | |||
import external data from changing file name | Excel Worksheet Functions | |||
How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) |