Hi Rick,
Thank you for the offer. I am very familiar with Microsoft Access so I am currently using this as my basic for this conversion.
The fields "Ph is hourly precipitation" and "P is total precipitation" have me stuck and I am hoping you or someone out there can clarify how these fields are used.
- First, I have to believe the format for these fields are in millimeters but cannot find anything to confirm this.
- For Hourly Precip, is this a value for the sum of the past 60 minutes of records? Does this value reset a midnight?
- For Total Precip, what is the starting point... first of the month, start of the day, etc?
Knowing these will help me extract the my data properly. As I mentioned in my original post I have data going back to 2007 on a 5 minute interval so that equates to a lot of data. Any help will be greatly appreciated.
Jay