ImportXML Method

[Trev]

A2K2
If I use:
Application.ImportXML "MyFile.XML", acStructureAndData
I get a table in my database, not ncessarily called "MyFile". So without
building an array of tables then comparing afterwards, how do I find out
what table was created just then?

Any way there's a chance of linking to an XML file?

[David Schofield]

On Tue, 05 Oct 2004 17:26:01 +0100, "Trev@Work" <no.email@please>
wrote:

A2K2
If I use:
Application.ImportXML "MyFile.XML", acStructureAndData
I get a table in my database, not ncessarily called "MyFile". So without
building an array of tables then comparing afterwards, how do I find out
what table was created just then?

Any way there's a chance of linking to an XML file?

Hi
The name of the table is the root element in the XML file. Access
appends a number to the table, if a table with that name already
exists.
See
http://msdn.microsoft.com/library/de...dc_acxmlom.asp
David

[David Schofield]

PS perhaps I didn't read your q closely enough, did you mean how to
find out which number was just added? I'm sure you would have to keep
track of this yourself. David

[Trev]

David Schofield wrote:

PS perhaps I didn't read your q closely enough, did you mean how to
find out which number was just added? I'm sure you would have to keep
track of this yourself. David

It was the original name from dataroot but now you come to mention it,
any Tom, Dick or Harry could name that with the name of an existing
table so it could exist already.

Looks like I will have to loop all the tables and play "Spot the newbie" :-)