Import XML via makro

http://technet.microsoft.com/en-us/library/ee692914.aspx

Hi Teery


Tak for dit svar.


Jeg er ikke den store VBA kender.

Kan det ikke lade sig gøre med en almindelig makro, og vælge tranferetext ?


MVH

Tony

Well I am no expert at macro's in Access, I prefer doing things VBA.
An idea would be to import the xml using teh import wizard at at some stage you can save the import steps.

Then you can make a macro which runs the import specifaction you have just made. (RunSavedImportExport)

Hi Terry


I dont think access 2003 support saving import action ?
(We use access 2003 on work)




Regards

Tony

Hi Terry


Do you have a suggestion to a vba code import a XML file ?


Test.xml  to a table named test.xml


Regards

Tony

I'm working with Access 2010 but have a Virtuak PC with 2003 on so I'll take a look later today if thats OK?

http://msdn.microsoft.com/en-us/library/aa221346(v=office.11).aspx

The link I gave 11:36 works fine, this is similar. Place a button on a form and in the On click event use this


Application.ImportXML "c:\test\test.xml", acAppendData

Hi Terry


Working perfect.

Thank You


One question more ....

The xml file contains more that one table, can the vba control
so only one table are imported ?

Regards

Tony

Hi
Not sure if its possibkle using the ImportXML method.

Is the any reason why they shouldnt be in multiple tables? You can maybe make a query to JOIN the tables

Hi Terry


It is not a big problem.


The XML file contains 5 tables, and i only need to work with one of them, so it is only to keep the DB clean.



Tks for you help again

Regards

Tony