[AccessD] Export to Excel URGENT!

It's Excel trying to be to smart I think. It thinks it's a number and that 
you want to look at it as a number, but it's really not a number it's an ID. 
And don't be messin with my ID's !

Did you make an OUTPUT Specification? Define the field as text there?

Or how about if you make a query with a 
format([fieldname],"00000000000000000") and then export the query instead of 
the table?  Or concatinate a space to make it into an alpha.

Adding a dummy first record with XXXXXXXXXXXXXXX in the field so that Excel 
sees the field as a text field has worked for me too. Then you delete or 
ignore the dummy on the Excel side

Good luck.

Gary Kjos
garykjos at hotmail.com





>From: "Terri Jarus" <jarus at amerinet-gpo.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: <accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Export to Excel URGENT!
>Date: Wed, 04 Feb 2004 06:46:04 -0600
>
>Can't you reformat the column to Number with 0 decimal places?  Works for 
>me.
>
>Terri Jarus
>Director, Contract Support Services
>jarus at amerinet-gpo.com
>314-542-1902
>
> >>> stuart at lexacorp.com.pg 02/04/04 06:04AM >>>
>What format is the ID in your Access table?
>
>Does the number need to be treated as a number in Excel? If not, just
>leave the initial single quote there.
>
>
>On 4 Feb 2004 at 2:00, S D wrote:
>
> > Hi group,
> >
> > i've got a big problem. I exporting 18 digit numbers to Excel.
> > Like 123456789012345678. This is an ID.
> > The ID's are copied to Excel. When I open Excel I see numbers 
>like:8.72E+17
> >
> > I've tried reformating the column/row to TEXT but it didn't work. When
> > I directly type the number into Excel it works. The 18 digit number
> > doesn't reformat. When I export it to Excel using a ' (quote?) sign
> > and then manually remove the ' it also works. When i use Find &
> > replace the number is reformatted to 8.72E+17?!
> >
> > Please help me with this one.
> >
> > Sander
> >
> > PS: I'm exporting thousands of ID's every 5 minutes....I do NOT want to 
>suggest "Do it manually"
> >
> >
> > ---------------------------------
> > Do you Yahoo!?
> > Yahoo! SiteBuilder - Free web site building tool. Try it!
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
>
>
>--
>Lexacorp Ltd
>http://www.lexacorp.com.pg
>Information Technology Consultancy, Software Development,System Support.
>
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>
>
>---------------------------------------------------------------------------
>This email and any files transmitted with it are confidential and
>intended solely for the use of the individuals or entities to whom they
>are addressed. If you have received this email in error please return
>it to the sender, and erase any copies thereof.
>Copyright 2004 Amerinet 1nc.
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Get a FREE online virus check for your PC here, from McAfee. 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963