lookforsmt
Registered User.
- Local time
- Today, 07:56
- Joined
- Dec 26, 2011
- Messages
- 672
HI! i have a table which is imported from excel every hour. From the cross-tab query the data is retrieved. Since the data is quite huge it cannot be stored in the db, so i only want to capture the summary every hour and store the values.
My challenge is how do i move the query data to "tbl_Summary" table as shown in attached snapshot
Below are the hours:
08:00 - 09:00
09:00 - 10:00
10:00 - 11:00
11:00 - 12:00
12:00 - 01:00
01:00 - 04:00
I can run the insert query every hour by changing the hour (01:00-04:00) field in the insert query each time. However i am looking at automation to avoid manually changing the hours.
Any possible solution.
Thanks
My challenge is how do i move the query data to "tbl_Summary" table as shown in attached snapshot
Below are the hours:
08:00 - 09:00
09:00 - 10:00
10:00 - 11:00
11:00 - 12:00
12:00 - 01:00
01:00 - 04:00
I can run the insert query every hour by changing the hour (01:00-04:00) field in the insert query each time. However i am looking at automation to avoid manually changing the hours.
Any possible solution.
Thanks