Hi
I have created a query with all of the fields that I need and it looks exactly how I want it. I can export this as a .txt or .csv file but when I look at the data any fields that contact a data display the date and time (dd/mm/yyyy hh:mm:ss) and I have formatted the field in the query so that it displays as DD-MMM-YYYY in the datasheet view. I need to export the data with this formatting as this is how the system requiring the data needs the file to be displayed.
So my questions two-fold:
1) how do I export so that the formatting is included in the export
2) can I export as a .dat without simply manually changing the extension afterwards?
My knowledge of access is very limited. I have enough knowledge to build something pretty simple, which is lucky because that's what I've done - but this exporting business is beyond me really so I would be grateful of any help.