Results 1 to 4 of 4

Thread: Converting a .xml into different formats

  1. Nov 6th, 2002, 09:05 AM #1
    plenderj
    plenderj is offline

    Thread Starter
    Retired VBF Adm1nistrator plenderj's Avatar
    Join Date
    Jan 2001
    Location
    Dublin, Ireland
    Posts
    10,359

    Converting a .xml into different formats

    Anyone have any ideas on how you'd go about converting a .xml file into an excel spreadsheet, or into an access database or something ?
    Microsoft MVP : Visual Developer - Visual Basic [2004-2005]
    Reply With Quote Reply With Quote
  2. Nov 6th, 2002, 09:08 AM #2
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687
    I would first decide what are to be made into rows and what is to be made into columns. Then it should be fairly simple to load the XML into a MSXML object, roll throug the elements, extracting the appropriate data and puttining it into the destination -- an Excel app, or Access (I would use ADO for this).
    I'm guess ing it would be easier to import it into Access (or any database) than Excel.
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  3. Nov 6th, 2002, 09:19 AM #3
    DeadEyes
    DeadEyes is offline
    Frenzied Member DeadEyes's Avatar
    Join Date
    Jul 2002
    Posts
    1,196
    Two new methods have been added to the
    Microsoft Access 10.0 Object Library for handling XML:
    ImportXML and ExportXML.

    A quick search should sort you out
    Reply With Quote Reply With Quote
  4. Nov 6th, 2002, 09:40 AM #4
    plenderj
    plenderj is offline

    Thread Starter
    Retired VBF Adm1nistrator plenderj's Avatar
    Join Date
    Jan 2001
    Location
    Dublin, Ireland
    Posts
    10,359
    Cheers guys I'll give it a go
    Microsoft MVP : Visual Developer - Visual Basic [2004-2005]
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width