Exporting date w/o time complicated

[Amthyst826]

I have a source excel file which I am pulling fields into my query to output as a text file
The field names in the source excel file are different than my desired output
Therefore, for example I have this in the Field of my query MOD DATE: Last Chg#

The final resulting table is over 300k rows
When I export it, I cannot leave the table layout and formatting on the file
Access add 0:00:00 as time and it is totally messing up my end file



I have been trying to figure out how to add Format([FieldName[,"mm/dd/yy") to the field expression but quite get it

Suggestions??

[ranman256]

Not sure what you said, but if you want a field that has the date in it:
Format([FieldName],"mm/dd/yy")

(this works ONLY IF the field has a date in it)

[Amthyst826]

The field displays correctly in Access mm/dd/yy
I need to export the table, which is over 300,000 rows
I can not export the table with formatting
When I open my exported file, Access has appended 0:00:00:00 to the date
mm/dd/yy 0:00:00:00
Because of the formatting I am trying to achieve, the zero's are bumped to the next column, misaligning my data with my headers.
I have "played" with the formatting of my table and with the formatting in the Make Table query I used to generate the table.
If I could leave the table layout and formatting on my file, it would be fine. But I have too many rows of data being exported.

[Amthyst826]

Can anyone offer some assistance on this one?
Date fields formatted to mm/dd/yy are appending time to the field on export