Hi,
I attached an image that describes the data in the spreadsheet I am working with. The spreadsheet is about 700 rows and was created using Excel.
The end goal is to import a portion of the data into a database (MySQL and probably Oracle). The only data that should be imported is the Fiscal Year, Building, and the monthly data (July through June).
I really do not want to resort to manually copying/pasting the data into a text file and importing it into the database. Please tell me there is an easier way :-)
Would you believe all of this data was manually entered ?!
Thank you for your help,
Nick
Bookmarks