1 Topic by Wolfgang

  • Wolfgang
  • Member
  • Offline
  • Registered: 05-09-2012
  • Posts: 39

Topic: Export to Excel

Hello,
we have upgraded to Recorder 6.18.1.260 in a test database. Now we are having problems with exporting reports.
If I run a "Quick Report" from a location, it opens up the report. If I then do an Excel report, it produces an Excel file, where the data are spread all over the table, not really randomly, but not in a structured way either.
We are using Excel 2003, SP3.
Who can help?

Thanks,
Wolfgang
Hampshire Biodiversity Information Centre

2 Reply by sallyrankin

  • sallyrankin
  • Administrator
  • Offline
  • Registered: 07-04-2006
  • Posts: 371

Re: Export to Excel

Which quick report are you referring to? Occurrences for Places and Places for Occurrences have never exported well to Excel using the ‘Export report’ button on the active window toolbar. Even in Recorder 2000, this facility didn’t produce a useful Excel file. It simply dumps what you see in the print preview into Excel so you end up with species names and dates in the same column etc.

Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687

3 Reply by Wolfgang

  • Wolfgang
  • Member
  • Offline
  • Registered: 05-09-2012
  • Posts: 39

Re: Export to Excel

Hello Sally,
Your description of what the tool does, is quite accurate. So it looks like it is something, which is not due to our installation, but that's simply, how it works in Recorder.

Wolfgang