Hi all,
I have to import a XML file in Access database as tables. When i import it directly I get 13 tables in Access database. I use the method Application.ImportXML (DataSource:=,ImportOptions:=) for importing.
But to reduce the tables to 1 and take only the data which is needed I am using a XSLT transformation.
I need to do it using VBA code. Application.importXML is not having that feature of uincluding transformation.
Is there any method to do it???
Thanks in advance
I have to import a XML file in Access database as tables. When i import it directly I get 13 tables in Access database. I use the method Application.ImportXML (DataSource:=,ImportOptions:=) for importing.
But to reduce the tables to 1 and take only the data which is needed I am using a XSLT transformation.
I need to do it using VBA code. Application.importXML is not having that feature of uincluding transformation.
Is there any method to do it???
Thanks in advance