ACCESS FEED: RE: [MS_AccessPros] Format Disable when Export to Excel

Kamis, 30 Agustus 2012

Formatting does not change how the data is stored, and when you export to Excel
you are sending the raw data. What do you want the numbers to look like?

Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT <http://thatlldoit.com/> http://thatlldoit.com
MS Access MVP

<https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E>
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E

My Nothing-to-do-with Access blog

<http://wrmosca.wordpress.com> http://wrmosca.wordpress.com

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Mas Shine
Sent: Thursday, August 30, 2012 3:10 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Format Disable when Export to Excel

I have a query with 3 fields, A(text),B(number),C(number) I have set the
format foro B & C to "Standard", If I run the query the format is works
fine.

BUT when I export those query to excel using docmd.transferspreadsheet
the format setting is disable so the result in excel is B & C have no
format.

How to include the format to excel file ?

Thanks

[Non-text portions of this message have been removed]