[AccessD] A2K, Export to Excel

arg.  well I've moved on since that but I'm still curious why this
occurs.. it is very frustrating.. :|


On Tue, 9 Nov 2004 22:12:58 +0100, Erwin Craps - IT Helps
<erwin.craps at ithelps.be> wrote:
> Aha, yes, know that prob.
> 
> Export without formatting and openening excel options. Just straight in
> to a file...
> Problem solved.
> Changing the cell format does not solve this issue.
> For me this is a bug that is present since A2K
> 
> Erwin 
> 
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
> Sent: Tuesday, November 09, 2004 12:03 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] A2K, Export to Excel
> 
> Hi Francisco
> 
> Try setting the format property of the field in the query to "Number"
> and two decimals. If this doesn't help, you may need to fall back to use
> Format() in an expression.
> 
> /gustav
> 
> > A friend has a query, and is exporting the results to an excel file,
> > for some reason the numeric (dollar) values are converted to string in
> 
> > excel (the single ' quote problem) it's easy enough to convert excel
> > to see it as a numeric but why?
> 
> > thanks,
> > --
> > -Francisco
> 
> --
> _______________________________________________
> 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
> 


-- 
-Francisco
http://pcthis.blogspot.com | PC news with out the jargon!