Exporting reports to Excel.

[Frank]

Hai,

When I export a report from Access to Excel with a remarks
field in it, I have the problem that all the remarks are
exported. This probably because a cell in Excel can only
handle 255 characters.

Can this be changed?

thanx

Frank

 

[Cameo]

For what purpose are you exporting to Excel? Is it because you need to share
the report with people who don't have Access?

If that is the case, you should consider creating a PDF file from your
report and sharing the PDF file instead.

Alternatively, you might consider exporting the report to Snapshot (.snp)
format and sharing that Snapshot file. The only caveat is that your
recipient will need to have either Access OR Snapshot Viewer (downloadable
free from Microsoft) loaded on their computers to read the snapshot file.

PDF readers are pretty much standard installs now, so if cost is not an
issue, you may want to invest in a full version of Adobe Acrobat to create
the PDF files. I believe there are free PDF file creating software out there
that might work for you, but I don't know their brand names.

Hope this helps.

Cameo