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??