J
JMark
Greetings. I trust this is the correct location for a fledgling
Accessor to ask this: I am seeking an elegant approach to create an
A2003 "data warehouse" which will allow me to run simple queries and
reports on historical data refreshed daily.
By data warehouse, I mean I want to link, on a daily basis, an
excel2003 spreadsheet, "Alarm Report" containing five days of data and
have those five days overwrite the last five days of an "Alarm_History"
table in A2003. Thus, as the Alarm_History table accumulates older
data, the latest five days will always be refreshed. I need to do this
as some of the data may be modified at any time during the previous
five days from Today().
I suspect the approach is to delete the last five days of
Alarm_History, then append my daily spreadsheet to it, but I'd like
additional thoughts. There are no key fields in the linked tables
because multiple events may occur at the same time and date, but by
different individuals. And the same individial may create multiple
events at differnet dates and times.
A unique event would be defined by: F2+F7+F8+F9+F10 where F2 = text and
F7, F8, F9, and F10 are date/time.
I look forward to any suggestions.
Thanks,
JMark
Accessor to ask this: I am seeking an elegant approach to create an
A2003 "data warehouse" which will allow me to run simple queries and
reports on historical data refreshed daily.
By data warehouse, I mean I want to link, on a daily basis, an
excel2003 spreadsheet, "Alarm Report" containing five days of data and
have those five days overwrite the last five days of an "Alarm_History"
table in A2003. Thus, as the Alarm_History table accumulates older
data, the latest five days will always be refreshed. I need to do this
as some of the data may be modified at any time during the previous
five days from Today().
I suspect the approach is to delete the last five days of
Alarm_History, then append my daily spreadsheet to it, but I'd like
additional thoughts. There are no key fields in the linked tables
because multiple events may occur at the same time and date, but by
different individuals. And the same individial may create multiple
events at differnet dates and times.
A unique event would be defined by: F2+F7+F8+F9+F10 where F2 = text and
F7, F8, F9, and F10 are date/time.
I look forward to any suggestions.
Thanks,
JMark