I have an excel spreadsheet that comes with header info that you can see in the attached spreadsheet. I would like to capture the contents of lines 3 - 7 after the colon and put those contents into a table with the associated fields. This table would be overwritten with new contents every time a new/different BOM is imported into the Access routine. Currently I bring the raw BOM into a table then take the fields using Like "<FieldName>:*". I take the whole field including the field name and dump it into separate tables. Getting them all into one table with 5 fields would be optimum.