[dba-Tech] XML to access?

Jon,

Since nobody else has bitten on this one, you can try using the following:

Application.ImportXML ("c:\somexmlfile.xml"), acStructureAndData

if you only have an xml file. Compare the files to ensure that you have
all of the data. If data is stored as attributes then you are going to
need to do a transformation, and then I'm lost as last year's easter eggs.

Does the export from the host generate an xsl ans well as an xml file?

Jim



> Hi all
>
> I've not used access much, but as the IT guy here, I've been asked to try
> and find a way to import data into an access db from an xml sheet, which
> is
> seemingly the only way we can oupput from the software we have.
>
> So in view of it being the blind leading the blind, as such, is there a
> SIMPLE way to do it?
>
>
> Jon
>
>
> The information in this e-mail is confidential and may also be legally
> privileged. The contents are intended for recipient only and are subject
> to the legal notice available on request from : webmaster at alcontrol.co.uk
> ALcontrol Laboratories is a trading division of ALcontrol UK Limited.
> Registered Office: Templeborough House, Mill Close, Rotherham, S60 1BZ.
> Registered in England and Wales No 4057291
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>