Help Needed on extracting tables from Access

[sameerkadoo]

1. I am trying to extract table from Access in XML format. On completing the extraction, the XML dissappears from the folder where it was stored.....


2. Also, How do i see SQL query for table in Access... the SQL view option is not seen in the ACCESS dropdown.

[June7]

Tables don't have an SQL view, only queries do.

I have no idea why the XML file disappears. Show your code.

[sameerkadoo]

I fixed the XML problem. It now appears.
I want to modify the date format when i export the data from access to XML...
yesterday, i used the Format([mydate],mm/dd/yyy) As Mydate...... which worked for query, but is there any solution for table? to format data while exporting?

[June7]

I don't think so, not if you are using import/export wizard or the DoCmd.TransferText. Unlike the Format function, the format property setting does not convert the data.