[AccessD] Access 2K to Excel changes field format

Charlotte Foust cfoust at infostatsystems.com
Thu Mar 9 14:47:26 CST 2006


In the query, concatenate a single quote to the front of the value.
Excel will see that as text and leave it alone.

Charlotte Foust


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of O'Connor,
Patricia (OTDA)
Sent: Thursday, March 09, 2006 12:21 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Access 2K to Excel changes field format


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.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list