Hello,
We have temperature data that is automatically collected. The data can only be downloaded into an excel format. I want to import this data into an access database. It would import it using a button on the form and bring it into a subform. I created a button and some code. Problem is, it imports the data into the table, but the linking field (LoggerID) is missing and the data is not shown in the subform. Any hints or suggestions. Attached is a picture showing relationship and form (with code on bottom) that I have built.
Cheers
Nick