cres1121
asked on
Exporting from Access 2016 to a CSV file
This is a two parts question.
I have a access query in the column format that I want. I even changed the query for the fields are in the correct order in the design view. I run the query and the columns look great. I then do the manual steps to create a CSV file and it does that fine. File is saved but the actual files have the columns in a completely different order then I was viewing on my screen.
I would like to export my query to a csv file in the correct format every time.
I would also like to then have the docmd to add to my macro to create the csv file for me and email it. out.
I have a access query in the column format that I want. I even changed the query for the fields are in the correct order in the design view. I run the query and the columns look great. I then do the manual steps to create a CSV file and it does that fine. File is saved but the actual files have the columns in a completely different order then I was viewing on my screen.
I would like to export my query to a csv file in the correct format every time.
I would also like to then have the docmd to add to my macro to create the csv file for me and email it. out.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Use the Format() function.
Select Format(SomeDate, "mm/dd/yyyy") as FormattedDate, ...
Select Format(SomeDate, "mm/dd/yyyy") as FormattedDate, ...
ASKER
Rey or anyone can you help me to export a date in a particular format with no time stamp?