Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a situation where a .CSV files(approx 380,000 rows) containes a lot of
data that I do not need. being rather new to scripting I am unsure how to get this loaded properly. I has found ways to split the file and to have it import into multiple sheets where I may then manually scrub to the data I need. I was wondering if it is possible to select only the rows in the CSV file that I need on the way in thereby saving me a lot of time by not having to manually scrub the 300,000 rows I do not need. I do not have access available to me for any of this and I only have Excel 2003(hence the splitting and mutiple worksheets). Is this possible at all? Thank, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Import link update filtering | Excel Discussion (Misc queries) | |||
How do I import text file, analyze data, export results, open next file | Excel Programming | |||
Import text file into excel with preset file layout, delimeters VBA | Excel Programming | |||
Filtering Text File Import | Excel Programming | |||
Database Filtering and Import or Copy to Remote Client Workbook | Excel Programming |