Importing csv to Access, ignoring header file part

[Canucklehead]

HI I have .csv files I'm trying to import and I can't seem to figure out how to get past the header portion of the log files to the records I want. For example I want it to skip over the first part of the file below and retreive the portion after "LINE# "

Thanks!




=======Event data log event list (begin)======= [Event #1 name: ]--[Event #1]Dec-08 2008 09:14<-->Dec-08 2008 16:34[Event start time: ]--Dec-08 2008 09:14:24[Event end time: ]--Dec-08 2008 16:34:24[Event #2 name: ]--[Event #2]Nov-20 2008 08:12<-->Nov-20 2008 08:12[Event start time: ]--Nov-20 2008 08:12:09[Event end time: ]--Nov-20 2008 08:12:09 ========Event data log event list (end)======== ==========Event #1 information (begin)========== ==============================================================================[Event #1 name: ]--[Event #1]Dec-08 2008 09:14<-->Dec-08 2008 16:34[Event start time: ]--Dec-08 2008 09:14:24[Event end time: ]--Dec-08 2008 16:34:24 ===========Event #1 head information=========== Product Name: ppbRAE 3000 Model Number: PGM-7340 Serial Number: 594-001537Data Points: 440 Sample Period: 60 s Datalog Mode: ManualSITE ID: RAE00000 USER ID: 00000001 Op Mode: Hygiene Mode ======================================================================Sensor Information : PID-Min(ppb)PID-Avg(ppb)PID-Max(ppb)Measurement Gas : Isobutene Calibration Time : 2008-12-08 06:42:002008-12-08 06:42:002008-12-08 06:42:00Drift Value : --- --- --- Low Alarm Levels : 5000 5000 5000 High Alarm Levels : 25000 25000 25000 Span Value : 10000 10000 10000 Correction Factor : 1.00 1.00 1.00 Over Alarm Levels : 10000000 10000000 10000000 ===========Event #1 data informations=========== LINE# Date/Time PID-Min(ppb)PID-Avg(ppb)PID-Max(ppb)1Dec-08 2008 09:15 0002Dec-08 2008 09:16 0003Dec-08 2008 09:17 000

 

[HiTechCoach]

HI I have .csv files I'm trying to import and I can't seem to figure out how to get past the header portion of the log files to the records I want. For example I want it to skip over the first part of the file below and retreive the portion after "LINE# "

Thanks!




=======Event data log event list (begin)======= [Event #1 name: ]--[Event #1]Dec-08 2008 09:14<-->Dec-08 2008 16:34[Event start time: ]--Dec-08 2008 09:14:24[Event end time: ]--Dec-08 2008 16:34:24[Event #2 name: ]--[Event #2]Nov-20 2008 08:12<-->Nov-20 2008 08:12[Event start time: ]--Nov-20 2008 08:12:09[Event end time: ]--Nov-20 2008 08:12:09 ========Event data log event list (end)======== ==========Event #1 information (begin)========== ==============================================================================[Event #1 name: ]--[Event #1]Dec-08 2008 09:14<-->Dec-08 2008 16:34[Event start time: ]--Dec-08 2008 09:14:24[Event end time: ]--Dec-08 2008 16:34:24 ===========Event #1 head information=========== Product Name: ppbRAE 3000 Model Number: PGM-7340 Serial Number: 594-001537Data Points: 440 Sample Period: 60 s Datalog Mode: ManualSITE ID: RAE00000 USER ID: 00000001 Op Mode: Hygiene Mode ======================================================================Sensor Information : PID-Min(ppb)PID-Avg(ppb)PID-Max(ppb)Measurement Gas : Isobutene Calibration Time : 2008-12-08 06:42:002008-12-08 06:42:002008-12-08 06:42:00Drift Value : --- --- --- Low Alarm Levels : 5000 5000 5000 High Alarm Levels : 25000 25000 25000 Span Value : 10000 10000 10000 Correction Factor : 1.00 1.00 1.00 Over Alarm Levels : 10000000 10000000 10000000 ===========Event #1 data informations=========== LINE# Date/Time PID-Min(ppb)PID-Avg(ppb)PID-Max(ppb)1Dec-08 2008 09:15 0002Dec-08 2008 09:16 0003Dec-08 2008 09:17 000

Since you did not wrapped the test with e CODE tag, it is hard to read. I am trying to see if I can clean it a up . Woudl it be possibel for you to edit your post and add the CODE tags.


I think you will probably want to use VBA code to process the file.