[AccessD] A2K, Export to Excel

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