[dba-Tech] XML to access?

Thanks Jim, Francisco and Marty, I'll pass these on to the guy that asked
me. I know we've only got Access 2000 here, and I'm pretty sure he told me
that the data can only be exported as XML. I'll see what he says.


Jon

-----Original Message-----
From: Jim Moss [mailto:jim.moss at jlmoss.net]
Sent: 01 September 2005 19:25
To: Discussion of Hardware and Software issues
Subject: Re: [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
>


_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com


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