Decimal Year to Normal Year Format Change
Posted on 2009-02-24
I have a file in Excel that has the date in decimal year format.
I am Importing this file to Access, by Opening the file in an Excel Applicaiton, and then using the ExcelSheet.Range option, I add them to my Access Table with my ADODB recordset.
The problem now is the format.
I have Attached a file that has the initial format, and beside it is the final format that I want to achieve.
*** The wanted result is NOT CORRECT and is NOT CORRESPONDING to the initial data, it is only used to illustrate the format :)
The data follows a similar pattern throughout, and this is hourly data for about 10 years.
Thanks in advance.