ajb1965
09-26-2017, 06:52 PM
Hello all,
I'm a complete rookie at VBA and macros so I apologize if this is rudimentary stuff. I searched Google and then the forums here and couldn't find what I was looking for.
I am trying to extract specific information from a text file and place it in three Excel columns horizontally so that I can then import it into Access as a table. Via Google I was able to get the three specific fields into excel the way I want it, but it only finds the first instance of each field then stops. I want it to scour the entire file and fill the cells with the data.
The fields I'm looking for in the file will have additional data to the right of the field name, and that data can be different throughout the file.
I've attached a sample of the raw text and the spreadsheet. The text files can get upwards of 2meg so they contain a lot of data.
If you could give me a few pointers or send me down the correct path towards where I can learn to do what I need to do I'd greatly appreciate it.
Cheers,
AJB
I'm a complete rookie at VBA and macros so I apologize if this is rudimentary stuff. I searched Google and then the forums here and couldn't find what I was looking for.
I am trying to extract specific information from a text file and place it in three Excel columns horizontally so that I can then import it into Access as a table. Via Google I was able to get the three specific fields into excel the way I want it, but it only finds the first instance of each field then stops. I want it to scour the entire file and fill the cells with the data.
The fields I'm looking for in the file will have additional data to the right of the field name, and that data can be different throughout the file.
I've attached a sample of the raw text and the spreadsheet. The text files can get upwards of 2meg so they contain a lot of data.
If you could give me a few pointers or send me down the correct path towards where I can learn to do what I need to do I'd greatly appreciate it.
Cheers,
AJB