Link to home
Start Free TrialLog in
Avatar of cres1121
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.
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cres1121
cres1121

ASKER

Okay Pat thanks for the heads up on changing the format.. That worked great.. points will be awarded.  

Rey or anyone can you help me to export a date in a particular format with no time stamp?
Use the Format() function.

Select Format(SomeDate, "mm/dd/yyyy") as FormattedDate, ...