[AccessD] Access Export to Excel

Jim Hewson JHewson at karta.com
Wed Jun 23 08:40:06 CDT 2004


Keith,
In my experience, the only way to ensure the "number" remains "text" in Excel is to prepend with an apostrophe ( ' ).  Also the first data element in the column determines the format for the entire column.  Prior to your export you'll need to add the apostrophe.  It won't show in Excel.
HTH
Jim


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Keith
Williamson
Sent: Wednesday, June 23, 2004 7:35 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Access Export to Excel


Hi all;

I'm sure this is an easy one, but.....I have a report that I am trying to
export to Excel.  One of the fields is a text field (example:  "0032", as
text).  When it exports to excel, it winds up truncating off the zeros, to
become "32", instead.  I really need this field to remain "0032".  Any
ideas?

Thanks in advance.

Keith E. Williamson
Ashland Equipment, Inc
phone # (410) 273-1856
fax #     (410) 273-1859

-- 
_______________________________________________
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