Okay, well actually it may not be difficult for some of you, but I was asked by my company to make a searchable database of 10,500 product data sheets by part number and type, and all the information that I need in the database is contained in the headers per file. They are NOT in forms, just in standard text within the header. I need to know if there was a way to automate the:
1. Separation of information within the header
and
2. Opening and extracting data from all 10,500 of them sequentially and automatically.
There are common 3-character strings at the beginning of each part number, if that is helpful.
If you think you can help me and you need more information, please let me know. I'm just an intern right out of high school so this is just a bit overwhelming.