Export report data to Excel

[GHawkins]

I'm trying to export the data from my report to Excel (File, Export, etc.).
When I open the workbook, some of the characters are being left out. Is there
a way to export ALL the data to Excel? I'm running Office 2003 SP2.

 

[Jeff Boyce]

Are you saying you want to export the report, not just the data?

If so, run the report in print preview, then select the toolbar button that
has the "W" and a drop-down arrow. Select Analyze with Excel.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[GHawkins]

This gave me the same results - some characters are omitted on the exported
file.

 

[Jeff Boyce]

Could you be a little more explicit?

Is it leaving out the letter "a"?

Is it dropping the last digit of a 10 digit number?

....?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[GHawkins]

At first it appeared that there was no rhyme or reason to what was being left
out - until I realized it was on the longer items. The characters are
actually being left out because it's hitting the 255 character limit for the
cells.

So now I guess my question changes - is there any way to get around this? I
know you can't get around the 255 character limit, but is there a way to
export a file and purge any extra characters to the next cell? I'm assuming
there's not.....but hope there is a way to do this!

 

[Jeff Boyce]

I seem to recall some limitations (255 characters) in export if any
formatting was applied. It sounds like you've found a 255 character limit
in the Excel cell.

That's a lot of characters ... what are you planning to do with all those in
Excel (that you cannot do in Access)?

Have you looked into using the Mid() function to grab out the first 255
characters, the next 255 characters, etc.?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[GHawkins]

It is a lot of characters, and I just found something else that is strange so
let me go into more detail. We have an Access database set up pointing to
Oracle. The database has English, Chinese, Thai, etc. characters in it. The
reports we're creating contain a combination of English and one other
language (like Thai). We want to export the reports to Excel so we can send
the spreadsheets to our international contact for translation (they can type
in the Excel cells, rather than printing a hard copy, writing in the
translations, and sending it back).

The first one we tried - with English and Thai - posed the problems of the
256+ characters being cut off. However, when we exported the Chinese report,
all characters came over. In fact, one of the cells had 700+ characters in it
- all of them were visible in the Excel cell. I am wondering why this report
didn't hit the character limitation - and is that really what is going on
with the first report?

I hadn't thought about using the first, mid, etc. functions, but not all of
the cells are going to hit the 255 character limit. And on top of that, how
do we know how many additional fields will be needed (for examples like the
Chinese language cell that had over 700 characters)? That's not really a
question for anyone on the message board to answer, but are there any other
options we can look at?

 

[Jeff Boyce]

One possibility would be to post over in the Excel groups. They'll likely
have more experience with the kind of import you are describing.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Charles Wang[MSFT]]

Hi,
To let me better understand this issue, could you please mail me
(changliw_at_microsoft_dot_com) a sample file for further research?
At my side, I can also save over 255 English characters in an Excel table
cell.

Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications

If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.


Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

 

[Charles Wang[MSFT]]

Hi,
I have not received your response. Please feel free to let me know if you
have any questions or concerns.

Best regards,
Charles Wang
Microsoft Online Partner Support

PLEASE NOTE: The partner managed newsgroups are provided
to assist with break/fix issues and simple how to questions.
We also love to hear your product feedback!

Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader:
microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

 

[S.Reul]

Hi, I suggest you go to www.utteraccess.com and search there or ask there.
usual you will get ur answer within a few hours.