Export to Excel "ERROR" in number fields
I have an issue when I export using MS Excel Spreadsheet all the field in Excel display "ERROR" instead of the number. Other types of fields display correctly. If I use MS Excel 2007 data type it is ok. When I check my query the data shows correct.
Has anyone else encountered this issue? Any Solutions?