Recent content by dalanaaccess

Hi, This is the following XML file I have. Please help me to change node <DistributionList> to be <CompanyList> in the same XML file using VBA? Thank you so much! <?xml version="1.0" encoding="utf-8"?> <DistributionLists> <List> <Name>Recon</Name>...

Well, I do not have 2 databases. I have one database and XML file with one record to add to database 1 in specific table.

I did not understand why excel file when I asked for XML. Please explain if you can. Thank you.

Hi All, I have XML file that was exported from DB1, Table A using VBA Sub Application.ExportXML. I would like to import the same file to BD2, Table B where Table A and B are identical with the same fields structure and names. Please help me if anyone have any idea. Thank you.

Works Great!! Thank you so much. I spend 3 days and you provide solution in few seconds. Very impressive.

Thank you, I will try that.

Hi All, I am trying to export only one record out of table to XML file. Of coursee I have qry ready and running qry only out of code works great. When I am using following code it is not showing anything, but it also not creating file. Application.ExportXML ObjectType:=acExportQuery...