[dba-Tech] XML to access?

Francisco Tapia fhtapia at gmail.com
Thu Sep 1 17:19:12 CDT 2005


Access 2003 also supports XML, it's as simple as just "Import" choose the 
xml file, and go..if the xml string does not have an xsl then you'll need to 
define field types, otherwise it's a quick wizard process.

On 9/1/05, Jim Moss <jim.moss at jlmoss.net> wrote:
> 
> 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
> 



-- 
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...



More information about the dba-Tech mailing list