import spreadsheet based on cell information. (1 Viewer)

Hello.

I have a spreadsheet that i want to import into an ExternalData table, basically it is normalised (i think) but to be sure i want to import cell values based on the values in other cells.

So looking at my spreadsheet there is a cell value (B6) that contains the value "Sample Description:", and at C6 is the SampleID i want to import into the table,

Then at C22 there is "KF Moisture (ASTM D6304 mod) mg/kg" which is what i want to import into the table field "Analyte" and beside that is the result i want to import into "Result" field.

How can i do a quick check to look for the SampleDescription and use the value it is found in rather than hard coding which cell it is in, so that if it is found at C8 it can still import it?

Has anyone done anything similar?

Which access version are you using?
From Acc2003 you can link the spreadsheet as an external table.
Using a query you can determine if you want to continue with this table or get on with the next.

HTH