If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
export date without time - comma delimited file
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 |
Thread Tools | |
Display Modes | |
|
|