[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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 6
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___