In query I set the format to "Standard" so I want when exported to excel it still have the format so I don't have reformat on excel.
I try docmd.outputo and can do what I want, the format is exported to excel to BUT it export to excel 5 by default not excel 8/9. Can't open excel5 on smartphone/tablet, I have submit this issue lastmonth, so Need to use docmd.transferspreadsheet.
Thanks
--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> 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]
>
Tidak ada komentar:
Posting Komentar