1 Reply by Giffdj

  • Giffdj
  • Veteran
  • Offline
  • From: KMBRC
  • Registered: 02-06-2008
  • Posts: 72

Re: Export Report Wizard results to Excel 2010

Hi,
Is it possible to export a large set of results (66k rows plus) direct to Excel 2010 or do you have to export to a text file then import them to the spreadsheet.
Cheers, Dave

2 Reply by MikeWeideli (edited by MikeWeideli 19-01-2011 18:59:50)

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Export Report Wizard results to Excel 2010

Recorder 6  doe not export directly to Excel 2010 (ie as an Excel Export). The process stops with an error message when it reaches the 65,536 rows. Probably you can export via an ADO link to  Excel file as the driver seems to be available, but my attempts so far haven't  worked.

Mike Weideli

MikeWeideli's Website