[AccessD] Access Export to Excel

I was just about to write a similar reply Jim.

You've saved me the effort.

Regards

Chris Foote - UK

> -----Original Message-----
> From: Jim Hewson [mailto:JHewson at karta.com]
> Sent: Wednesday, June 23, 2004 2:40 PM
> 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