Excel displays incorrect values when you export an Access report with

[littlealvin]

I am suffering from a problem that Microsoft is aware of and wrote this KB article: "Excel displays incorrect values when you export an Access report
with numbers"

http://support.microsoft.com/kb/823222/en-us

Anyone know if this KB article has been resolved yet?

 

[SkipVought]

Hi,

AFAIK, it has never been resolved.

But I have a question. Why are you exporting a REPORT to Excel? I abaolutely HATE getting a REPORT in Excel. It is almost useless unless you do alot of cleanup to TRY to format it as a TABLE.



Skip,
[sub]
[red][/red]
[/sub]

 

[littlealvin]

SkipVought, its not actually me- I'm an IT person who is providing support for an accounting department. They prefer this format and there is nothing I can do to talk them out of it. Exporting from Access2000 to Excel2000 works and had worked for them for years but when we upgraded them to Office2003 exporting from Access2003 to Excel2003 produces this problem. I need a fix (not a workaround) and found the appropriate KB article. I was wondering if Microsoft has solved this problem yet. Thanks for replying and if you have a solution, please let me know.

 

[SkipVought]

You can query MS Access, using an ADODB object, and then WRITE each value to the Excel sheet, adding the appropriate ' suffix when required. But that can only be done with tables/queries and not reports.

Skip,
[sub]
[red][/red]
[/sub]

 

[SkipVought]

There's really little advantage to putting some other applications report in Excel.

Why not just export to a .txt file or put it in MS Word.

Skip,
[sub]
[red][/red]
[/sub]

 

[littlealvin]

SkipVought, thanks for the workaround solutions. I think that if Microsoft gave us the ablity to export to Excel in 2003 and it worked fine in 2000 then its their responsility to make it work for 2003 also. I understand your frustration with users not wanting to see the data in the same format that you would yourself but they are the ones paying my paycheck so therefore I make the software work the way its supposed to work. Your help is appreciated though!

 

[SkipVought]

"...then its their (Microsoft's) responsility to make it work for 2003 also."

Dream on......


Skip,
[sub]
[red][/red]
[/sub]