Text Export changes data 1

[bravo6]

I'm trying to export a file per a custmomer spec. In the Access export wizard the file (Text- comma delimited)looks fine. But when I open the .txt file it has changed. Specifically this is the desired format and what it looks like in the wizard:

field,field,01/14/2007,01/16/2007,field,field,etc,.

When I open the exported file it has added a time behind the date and now looks like this:

field,field,01/14/2007 0000,01/16/2007 0000,field,field,etc.

Is there anyway to keep those zeros from showing up in my .txt file?

 

[Remou]

You can export a query with formatted dates.

 

[bravo6]

I've tried that. The format still converts from
"mm/dd/yyyy" to "mm/dd/yyyy 0000" when exported

 

[Remou]

Which version of Access are you using? This SQL:

[tt]SELECT Table1.ID, Format([DMY],"mm/dd/yyyy") AS Expr1
FROM Table1[/tt]

Exported as text/csv, results in:

[tt]1,"01/05/2008"
3,"01/07/2008"
4,"01/08/2008"[/tt]

Using Access 2000.

 

[bravo6]

I use Access 2003 but your answer is esentially what I have. Trying your suggestion this still adds in the time

 

[Remou]

I cannot think of a reason why this should not work. Here are two references, perhaps reading them will suggest something to you.

http://groups.google.ie/group/micro...e+microsoft+access+adds+time#1e59e059a511fbc1

http://support.microsoft.com/kb/291245

 

[bravo6]

Thanks, This revealed the real source of the problem. I had to create a new export specification to get this done. Nothing in the spec was wrong but was somehow corrupted. Trying the test table revealed where the problem was.

 

[SkipVought]

I would export in the UNAMBIGUOUS date format of yyyy/mm/dd, unless you have a different specification in your requirements.

Keep in mind that your export will be TEXT.

Most programs that IMPORT this data will CONVERT the TEXT representation of dates to a NUMBER that can be use in calculations and colation.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}