Exporting report into Excel

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!
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export report into Excel 1
Problem Exporting Images Over 5 MB to PDF 2
Access "OutputTo" Command HTML Template 0
Access 2007 - Export a Report 1
Exporting Query from Access 2007 to Excel 2007 4
Trouble exporting Report to Excel 1
copy and paste from datasheet to excel 4
msAccess Report Header export to Excel 3

Top