extract realtime excel data and transfer it into an Access database

[talhaparvaiz@yahoo.com]

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

[isladogs]

Is there a missing image (or two)?

Anyway, link to the Excel file from Access. The data will then be live.
Every hour, run an append or update query (as appropriate) to import the data as a snapshot at that time.
Include a datetime field with value Now() to obtain your timestamp

[pbaldy]

>>let's consider the Excel and Access tables in the following scenario:
>>it will show something like this

There are no pics in your thread if there were supposed to be. If you can link to the Excel file, you can simply run an append query hourly.

[talhaparvaiz@yahoo.com]

Here are the missing images:

[talhaparvaiz@yahoo.com]

I appreciate this suggestion and intend to test it out.


To ensure clarity:


1. I will keep my Excel file open while the data is being extracted live.
2. Access will be linked to the open Excel file.
3. I plan to create an append query in Access, which will extract data from step 2 and append it to the master table.
4. This append query will run every minute, ensuring that each appended record includes a date and time stamp in the master table.


Regarding your queries:


Q1. Could keeping the Excel file open cause any issues?
Q2. If the Excel file remains open, will it automatically save, or are there specific configurations/options I need to adjust to enable this?


Once again, thank you for your assistance.

Is there a missing image (or two)?

Anyway, link to the Excel file from Access. The data will then be live.
Every hour, run an append or update query (as appropriate) to import the data as a snapshot at that time.
Include a datetime field with value Now() to obtain your timestamp