export date without time - comma delimited file

Does anyone know how to export a table that has percents
and dates comma delimited without the slashes in the
date and without the time? And for the percentages, how
do I export with all the decimal places in tact as I see
on the table? When I export I don't get the trailing
zeroes?

i.e. I enter 012.7860000 when I export I get left
justified 12.786
Can someone help me?

Thanks in advance

On Thu, 3 Jun 2004 12:23:11 -0700, "
wrote:

Does anyone know how to export a table that has percents
and dates comma delimited without the slashes in the
date and without the time? And for the percentages, how
do I export with all the decimal places in tact as I see
on the table? When I export I don't get the trailing
zeroes?

i.e. I enter 012.7860000 when I export I get left
justified 12.786
Can someone help me?

Thanks in advance

If the field is numeric, those are just two different ways of
depicting the same number.

I'd suggest exporting from a Query using the Format() function to
convert the date or the percentage to a text string:

ExpDate: Format([datefield], "ddmmyyyy")
ExpPct: Format([numberfield], "000.0000000")


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public