ImportXML Method

[Trev@Work]

A2K2
If I use:
Application.Imp ortXML "MyFile.XML ", acStructureAndD ata
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]

Re: ImportXML Method

On Tue, 05 Oct 2004 17:26:01 +0100, "Trev@Work" <no.email@pleas e>
wrote:
[color=blue]
>A2K2
>If I use:
>Application.Im portXML "MyFile.XML ", acStructureAndD ata
>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?[/color]
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/default.asp?url=/library/en-us/odc_ac2003_ta/html/odc_acxmlom.asp

David

[David Schofield]

Re: ImportXML Method

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@Work]

Re: ImportXML Method

David Schofield wrote:
[color=blue]
> 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[/color]

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" :-)