Re: Importing from Office 2007
Has anyone had a problem importing data from a Microsoft Office 2007 spreadsheet (.xlsx)?
We received some data in an Office 2007 spreadsheet, which we converted to Office 2003 so that we could open it. We then imported the data into Recorder 6.
We found that Recorder changed all of the dates - it knocked off 4 years and 1 day off each date, so 06/06/99 became 05/06/95, 01/07/98 became 30/06/94.
I am assuming that this has something to do with how the different versions store dates. If you convert a cell that is in date format to general format it comes up with a string of figures - in an Office 2003 spreadsheet 01/06/00 is 35216, but in a spreadsheet converted from Office 2007 01/06/00 is 36678, and 35216 corresponds to 31/05/00.
Have any of you techie people got a solution for this? Or should we avoid data in Office 2007 format until Recorder 6 catches up?
Ellie
Eleanor Knott
Technical Co-ordinator
Devon Biodiversity Records Centre
C/o Exeter Central Library
Castle Street
Exeter
EX4 3PQ
Tel. (01392) 274128
http://www.dbrc.org.uk/
Devon Biodiversity Records Centre