extract data from Access

[sameerkadoo]

Hello,

I want to export data from access to XML and want to format the date field while exporting.


How do i do that?

Regards,
Sameer K

[June7]

Build query. Use Format function in query expression. Export the query.

SELECT Format([myDateField], "mm/dd/yyyy") As MyDate FROM tablename;

[sameerkadoo]

Thank you it worked...
Another problem i am facing now... tried to extract table from Access in XML format. On completing the extraction, the XML dissappears from the folder where it was stored.....
Also, How do i see SQL query for table in Access... the SQL view option is not seen in the ACCESS dropdown.

[June7]

Since you started another thread with those questions, will respond there.