Hello,
I possess an Excel file that gathers data from diverse sources, much of which is real-time.
My objective is to extract this data and transfer it into an Access database, accompanied by timestamps. This allows me to maintain hourly snapshots of the data.
To clarify further, let's consider the Excel and Access tables in the following scenario:
Requirement
At 9 AM, I want the data from Excel to be put into MS Access so that it will show something like this
Please advise how to achieve it... sample code will be appreciated.
Thanks