[dba-Tech] XML to access?

MartyConnelly martyconnelly at shaw.ca
Fri Sep 2 10:47:29 CDT 2005


One other way for older version of Access is read xml file into xmldom 
and convert to csv file via xslt
and import csv file into access table, long way around but I have the 
xslt transform lying around.
It should be on MS site somewhere.
There are a lot of different styles of xml formats.

Jon Tydda wrote:

>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
>_______________________________________________
>dba-Tech mailing list
>dba-Tech at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-tech
>Website: http://www.databaseadvisors.com
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the dba-Tech mailing list