Exporting report into Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi! I have an Access 2000-report that I want to export into Excel 2000. I
have tried creating a macro using the "Outputto" command. Unfortunately when
I open the Excel-file only the headlines and no other data from the report
have been transfered. Any ideas what to do? Thanks!
 
hi,
it has been my experiance that excel don't like access reports. not sure why.
so don't export the report. instead export the underlining query of the
report.
excel can handle that better. it may created some porblems if you have
running balances or totals in the report but this can be fixed in excel with
formulas.

IF you export this report to excel on a regular i would look into using
microsoft query in excel and link to the access query.

good luck
FSt1
 
Back
Top