[AccessD] Access 2K to Excel changes field format

O'Connor, Patricia (OTDA) Patricia.O'Connor at otda.state.ny.us
Thu Mar 9 14:21:28 CST 2006


Hi all

I have an ID field which is TEXT 14 characters

In the Access report it is being displayed correctly 66007573735D01

When this report is put to EXCEL through the "Analyze it through EXCEL"
it is dropping the D so the ID changes to 6.60076E+11  I have changed
the excel format to TEXT. If I then go to that cell highlight and leave
it will look like this 660075737350

I have the field formatted in the query and access report as text
@@@@@@@@@@@@@@. Is there something in excel or access that I have to
change in the options. This does not make sense and it is causing
problems sending the results to others.

Thanks

**************************************************
* Patricia O'Connor
* Associate Computer Programmer Analyst
* OTDA - BDMA
* (W) mailto:Patricia.O'Connor at otda.state.ny.us
* (w) mailto:aa1160 at otda.state.ny.us
************************************************** 
--------------------------------------------------------
This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments.  Please notify the sender immediately by reply e-mail and delete the e-mail from your system.



More information about the AccessD mailing list