| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import data from the middle of a text file
I want to import a range of data from a text file into Excel. I can specify
the starting row, but can't find a way to specify the ending row. Is it possible to do this? Does anybody have code that will do it? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Import data from the middle of a text file
Why not just delete the rows you don't want after it is imported?
What method are you using (post the code) -- Regards, Tom Ogilvy "Caol D" <Caol wrote in message ... I want to import a range of data from a text file into Excel. I can specify the starting row, but can't find a way to specify the ending row. Is it possible to do this? Does anybody have code that will do it? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Import data from the middle of a text file
Yes, I can do that, but I will be working with hundreds of files with
thousands of rows of data. For example, I have files with 8K rows, and only want to use a range of 100 rows. I'm trying to find a way to not have to import so much data in the first place. Carol "Tom Ogilvy" wrote: Why not just delete the rows you don't want after it is imported? What method are you using (post the code) -- Regards, Tom Ogilvy "Caol D" <Caol wrote in message ... I want to import a range of data from a text file into Excel. I can specify the starting row, but can't find a way to specify the ending row. Is it possible to do this? Does anybody have code that will do it? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Import data from the middle of a text file
How do you know which lines you want to import. It seems to me you either
have to traverse the text file line by line to determine what you need or you might be able to get away with an ADO recordset. Check out this link http://www.erlandsendata.no/english/...adacconnstring to find the connection string to use to connect to a text file. -- HTH... Jim Thomlinson "Carol D" wrote: Yes, I can do that, but I will be working with hundreds of files with thousands of rows of data. For example, I have files with 8K rows, and only want to use a range of 100 rows. I'm trying to find a way to not have to import so much data in the first place. Carol "Tom Ogilvy" wrote: Why not just delete the rows you don't want after it is imported? What method are you using (post the code) -- Regards, Tom Ogilvy "Caol D" <Caol wrote in message ... I want to import a range of data from a text file into Excel. I can specify the starting row, but can't find a way to specify the ending row. Is it possible to do this? Does anybody have code that will do it? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Import data from the middle of a text file
I have about 200 "types" of data files. Each type has a specific number of
rows. I have a matrix that will tell me what range of lines to extract for each "type" of file. Thanks for the link. I think I can use the information there to do what I need to do. "Jim Thomlinson" wrote: How do you know which lines you want to import. It seems to me you either have to traverse the text file line by line to determine what you need or you might be able to get away with an ADO recordset. Check out this link http://www.erlandsendata.no/english/...adacconnstring to find the connection string to use to connect to a text file. -- HTH... Jim Thomlinson "Carol D" wrote: Yes, I can do that, but I will be working with hundreds of files with thousands of rows of data. For example, I have files with 8K rows, and only want to use a range of 100 rows. I'm trying to find a way to not have to import so much data in the first place. Carol "Tom Ogilvy" wrote: Why not just delete the rows you don't want after it is imported? What method are you using (post the code) -- Regards, Tom Ogilvy "Caol D" <Caol wrote in message ... I want to import a range of data from a text file into Excel. I can specify the starting row, but can't find a way to specify the ending row. Is it possible to do this? Does anybody have code that will do it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import data from text file | Excel Discussion (Misc queries) | |||
| import data from a text file | Excel Discussion (Misc queries) | |||
| How do I import text file, analyze data, export results, open next file | Excel Programming | |||
| how to import data from text file which has more 70k rows ? | Excel Programming | |||
| Get External Data, Import Text File, File name problem | Excel Programming | |||
Hybrid Mode
