Export to Excel, keep format

[Ana via AccessMonster.com]

When I'm exporting table from Access to Excel, I lose all formating. Some
colums in table are Format Number, some are Currency without symbol, but when
I export them to Excel they all are format General. Is there any possible way
to keep them formated?

 

[Douglas J. Steele]

Not without having to write VBA code to do the export for you using
Automation.

 

[Ana via AccessMonster.com]

OK, I presume that I need VBA in order to do it. What would be code for it?
Only to keep format, like Currency-none symbol, or Number-percent ? I don't
need the column with, fonts or things like that...
If you could help me, I would be most grateful...

 

[Douglas J. Steele]

See whether what I had in my July, 2005 "Access Answers" column in Pinnacle
Publication's "Smart Access" is enough to get you going.

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[Guest]

When I'm exporting table from Access to Excel, I lose all formating. Some
colums in table are Format Number, some are Currency without symbol, but
when
I export them to Excel they all are format General. Is there any possible
way
to keep them formated?

 

[Ana via AccessMonster.com]

Dear Douglas,
I followed the link you gave me, and I looked into your database. You have
table named Order Details and in it you have column named Discount. While
exporting to Excel you are losing that format so from 5% you have in Access,
you get 0,0500000007450581 in Excel. That's just the thing I'm trying to
avoid. How can I get 5% in Excel???
Thank you!!!