[AccessD] Access Export to Excel

Keith Williamson kwilliam at ashlandnet.com
Wed Jun 23 09:02:54 CDT 2004


Thanks, guys.  I should have thought of that.  I must be getting old.  :)

Regards,

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

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Hewson
Sent: Wednesday, June 23, 2004 9:40 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Access Export to Excel

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