Export report info into Excel?

[CEV]

I have a report that I created and I am wondering if there is a way to
export this easily into Excel?

Thanks,

CEV

 

[fredg]

I have a report that I created and I am wondering if there is a way to
export this easily into Excel?

Thanks,

CEV

With your report displayed in Preview, (or simply select the report on
the Main Database folder) click on the Office Links tool button (it's
icon is a W) drop-down arrow and select Analyze it with Microsoft
Excel. The Excel file will be placed in the My Documents folder.

 

[CEV]

Thanks Fred!! That was easy!!

Thanks,

CEV

With your report displayed in Preview, (or simply select the report on
the Main Database folder) click on the Office Links tool button (it's
icon is a W) drop-down arrow and select Analyze it with Microsoft
Excel. The Excel file will be placed in the My Documents folder.

 

[CEV]

My report has a memo field. When I send the report to Excel, everything in
this field does not go to Excel, only a portion of it. Has this ever
happened to anyone else and how can I fix it?

Thanks,

CEV

 

[Peter YangMSFT]]

Hello Chad,

This is a known issue and you may refer to the following articles to work
around the issue:

294286 Memo field is truncated when you output a report to excel in Access
2002
http://support.microsoft.com/default.aspx?scid=kb;EN-US;294286

281153 ACC2000: When You Export an Access Report the Memo Field Is Truncated
http://support.microsoft.com/default.aspx?scid=kb;EN-US;281153

If you have any feedback or comments, please feel free to let's know. Thank
you.


Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================


This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Peter YangMSFT]]

Hi Chad,

I'm still interested in this issue. If you have any comments or questions,
please feel free to let's know. Thanks.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[CEV]

Those resolutions did not work. I have a button that we use to email the
report. The options to email include Excel 2003 format, but when opening
that Excel file, the memo field is still cut short of all the text.

Thanks,

Chad

 

[Peter YangMSFT]]

Hello Chad,


Selecting "Excel 2003 format" when exporting the report does not solve the
problem because Access still uses old version format in the background.

Since it's actually a product limitation, as discussed in KB 294286, we
have to export the table/query the report based on or use some tricky
method such as trim the split/reassemble strings by code.

Another workaround might be export the report to CSV or HTML file type.

If you have any further concerns or comments, please feel free to let's
know. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.