how are Reports in Access output to Microsoft Excel?

[Guest]

how are Reports in Access output to Microsoft Excel? Some of the information
when it is exported to Excel, it is truncated. HOw can I solve this problem?

 

[Marshall Barton]

how are Reports in Access output to Microsoft Excel? Some of the information
when it is exported to Excel, it is truncated. HOw can I solve this problem?

I don't know what you're trying to acomplish so I could be
off base, but, IMO, it's a little silly to format something
intended for a piece of paper and then send it to another
program.

Whatever. You could just export the report's record source
query (or an extended version of it) to get the
unadulterated data into Excel.

 

[Mark Andrews]

In general you can't control how the internal export capabablity of Access
works.

how are Reports in Access output to Microsoft Excel? Some of the information
when it is exported to Excel, it is truncated. HOw can I solve this

problem?

 

[Guest]

Thanks Marsh,

I still don't know how to deal with it: I try to export Access Reports to
Microsoft Excel spreadsheet that I experience that some of the long fields in
the Access Reports were truncated to fields with only 255 characters in Excel
spreadsheet. Do you have any idea that I can solve this problem?

Many thanks in advance.

ML.

 

[Marshall Barton]

I still don't know how to deal with it: I try to export Access Reports to
Microsoft Excel spreadsheet that I experience that some of the long fields in
the Access Reports were truncated to fields with only 255 characters in Excel
spreadsheet. Do you have any idea that I can solve this problem?

No, not if you export a report. If you export a query, I
would expect it to work or be an issue in the query. Report
are just too complex to reliably export to much of anything.

Maybe someone else has exported reports and knows the
pitfalls will jump in and answer this, but I doubt there is
any way to make a sheet look just like a report in most
cases.