Import XML file to specific table

[dalanaaccess]

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.

 

[Ranman256]

attach the xl file as an external table from a 'temp' file: c:\temp\File2Import.xls"
build a query to import the data into your target table
put the query in a macro.

then the steps are:
1. save and overwrite c:\temp\File2Import.xls"
2. run the macro.
done.

 

[Cronk]

Ranman, I don't think it's possible to link to an XML file.

Anyway, easier to use
application.importXML,"xxx.xml", acStructureAndData

 

[arnelgp]

inside DB1 use this code:

Dim db As DAO.Database
Set db=Currentdb
db.Execute "INSERT INTO " _
& "[Table B] SELECT * FROM [Table A] IN 'c:\db\DB2';"

'''''
change c:\db\ to the correct path of of DB2

 

[dalanaaccess]

attach the xl file as an external table from a 'temp' file: c:\temp\File2Import.xls"
build a query to import the data into your target table
put the query in a macro.

then the steps are:
1. save and overwrite c:\temp\File2Import.xls"
2. run the macro.
done.

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

 

[dalanaaccess]

inside DB1 use this code:

Dim db As DAO.Database
Set db=Currentdb
db.Execute "INSERT INTO " _
& "[Table B] SELECT * FROM [Table A] IN 'c:\db\DB2';"

'''''
change c:\db\ to the correct path of of DB2

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.