XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Code Samples & Utilities » Populating MS access from XML datafiles
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2016)
+ Stylus Studio FAQs (159)
- Stylus Studio Code Samples & Utilities (364)
-> + XSD to XML Creation with all O... (2)
-> - How XML to X12 be converted an... (1)
-> - Encode and decode XML to and f... (1)
-> + Evaluating StylusStudio - .cnv... (2)
-> - Build safe NCName (1)
-> - generating .Net dataset (1)
-> + Converters for .NET (2)
-> + TRADACOMS - Code Generation (2)
-> - Flat File Custom XML conversio... (1)
-> - Need help in Generate a checkb... (1)
-> + Evaluation period for the buil... (2)
-> + Reports with ifs (2)
-> + Need Help Creating Custom XML ... (6)
-> + Need help with unique particle... (10)
-> + In need for help on converting... (3)
-> - import xml into an access (1)
-> + jaxb support (3)
-> + Large XML sample file (2)
-> + Stylus Studio 2008 R2 - From X... (2)
-> + create an xml document with ex... (2)
-> + Default xml converter from com... (2)
-> + Transforming Data With XSLT (5)
-> + Error when creating pdf file (5)
-> + Got Shkespear XML Doc from web... (3)
-> + VFP 8 (2)
-> + CSV import (7)
-> + Generating X12 from XML (4)
-> + How to handle variable input &... (2)
-> + Grab html to xml (2)
-> + XML To X12 conversion using in... (3)
-> + XSLT mapping help required (2)
-> + convert XML to JAVA (2)
-> + Insert a carriage return or li... (3)
-> + Automatation for comparing two... (2)
-> - Filter records (1)
-> + BIT Fields (3)
-> + Restricted Mixed Content (4)
-> - Freelance Project - Mapping di... (1)
-> + flat file to xml conversion (10)
-> + ConvertFromXML to TXT (2)
-> + Edi X12 835 to Flat file (2)
-> + License problem (2)
-> + Removal of elements from an XM... (3)
-> + XSL and Word docs (2)
-> + Develop a workflow using xml (2)
-> + Need help converting CSV to Ne... (2)
-> + Specify valid values for an el... (3)
-> + Question about the WYSIWYG fun... (2)
-> + XML diff tool (4)
-> + Validating schemas (3)
-> + Best way to fix a few hundred ... (6)
-> + Mapping problem please help me (2)
-> + Relational Database Hierarchic... (2)
-> + RDBMS - XML round-tripping (3)
-> + Converto FILE to XML (2)
-> - relational database acces - lo... (1)
-> + unsupportet URL scheme when tr... (6)
-> + XML in oil industry (3)
-> - Want to get the available para... (1)
-> + XSL in HTML? (9)
-> + Help Creating a new wsdl (2)
-> + Extracting XML from a database... (6)
-> + Stylus Studio Converters comma... (18)
-> - Schema for RDF section within ... (1)
-> + Text to XML converter not in t... (4)
-> + Filtering data with a combo bo... (2)
-> + Loading data in XML file/docum... (2)
-> + Stylus StudioŽ's Web Service C... (2)
-> - How to replace a specific node... (1)
-> + xsl:result-document and multip... (2)
-> - Russian Doll Schema (1)
-> - Populating MS access from XML ... (9)
-> ->Populating MS access from...
-> ->Populating MS access from...
-> ->Populating MS access from...
-> ->Populating MS access from...
-> ->Populating MS access from...
-> ->Populating MS access from...
-> ->Populating MS access from...
-> ->Populating MS access from...
-> + xsd to xml (5)
-> + populating treeview control wi... (6)
-> + Problem generating a simple DT... (4)
-> + XML Newbie Basics (4)
-> + How do I ... Build an HTML Pag... (2)
-> + .NET API (6)
-> - Building Your Own Search Engin... (1)
-> - transformer.transform gives Ex... (1)
-> + reading xml (6)
-> + How to Display Links in XML (4)
-> - how to place the text of the f... (1)
-> + Need guidelines (3)
-> + Basic XML question (2)
-> + sql/xml returns invalid result... (2)
-> + SQL/XML Error (4)
-> - pass paramter in java and do a... (1)
-> + serialize java (2)
-> + pass paramter in java for xml ... (2)
-> + transform dtd to xml schema (2)
-> + Converter - xsd to xml (7)
-> + Convert to XML programmaticall... (2)
-> + XSL FO with Java data source (2)
-> - OASIS XML Catalogs Tutorial (1)
-> + Transforming XML to EDI (2)
-> + Using row data to populate XML... (7)
-> + Nesting Tables and Sub-Tables (2)
-> + XSL for multiple columns and c... (5)
-> + New Advanced CSV to XML Data C... (3)
-> - Java mapper (1)
-> - XML Spy project conversion to ... (1)
-> + APIs and OCXs (2)
-> + No Topic (2)
-> + Profiling (3)
-> + xsl to xslfo (5)
-> + Does anyone use XML from ADO ... (5)
-> - XML from ADO Wizard (1)
-> + Weird XQuery results? (3)
-> - XSV xml schema validator (1)
-> + Menu structure (2)
-> + XQuery user-defined functions (2)
-> + Passing Parameter to Templates (3)
-> + XML To Database (2)
-> + XML Schema xsd:any and xsd:any... (2)
-> - XSL-FO Webinar Sample Files (1)
-> + Name Element (2)
-> + date of the day (5)
-> + Is there a 'Find Definition' f... (2)
-> + DTD to schema conversion (2)
-> + Simple XSLFO Example (3)
-> - Post your favorite Stylesheet ... (1)
-- [1-20] [21-40] [41-60] Next
+ Stylus Studio Announcements (113)
Topic  
Postnext
John RedpathSubject: Populating MS access from XML datafiles
Author: John Redpath
Date: 23 Jan 2006 04:04 PM
I have XML data files that we receive from an outside entity. I want to be able to populate the data into an MS-Access database. It doesn't seem like there is a good import capability in Access to do this. I see that your software apparently has the ability to create schemas and it seems that is has some type of mapping capability. Am I looking at the right software to do this ?

Postnext
Tony LavinioSubject: Populating MS access from XML datafiles
Author: Tony Lavinio
Date: 23 Jan 2006 04:35 PM
Stylus Studio can certainly be used to update an Access database
from XML. For a pointer directly into the documentation, see
http://www.stylusstudio.com/docs/v2006/d_rdb35.html for the
documentation.

http://www.stylusstudio.com/xml_database.html has more information.
Since we provide the DataDirect Technologies SequelLink product,
your SQL code will run unchanged against Access, SQL Server, Oracle,
Sybase or any other database you need to run it against in the future.

Postnext
Susie ShafferSubject: Populating MS access from XML datafiles
Author: Susie Shaffer
Date: 06 Mar 2006 04:17 PM
Hi,

I need to import XML data into an Access Database. Access requires the XML to be element based, but the file I am working with is Attribute-based. It seems to me that I can create an element-based xml file using style sheets, and I was hoping your software could help me build a style sheet.

However, someone posted a similar question to mine and your response was:
"Stylus Studio can certainly be used to update an Access database from XML. For a pointer directly into the documentation, see
http://www.stylusstudio.com/docs/v2006/d_rdb35.html for the
documentation"

This link takes you to DB-to-XML documentation. I need XML-to-DB documentation.

Can you tell me the best way to proceed?
Postnext
(Deleted User) Subject: Populating MS access from XML datafiles
Author: (Deleted User)
Date: 06 Mar 2006 04:43 PM
Hi, Susie. In order to write back to the database (which is what I'm assuming you need/mean when you ask about XML-to-DB functionality), you need to define the appropriate SQL code on the UPDATE tab of the DB-to-XML Editor. When you save a DB-to-XML data source you have opened as XML in Stylus Studio, any UPDATE/INSERT actions you have defined are performed at that time.

A short video illustrating this procedure is described in the following thread.

http://www.stylusstudio.com/SSDN/default.asp?action=9&read=4754&fid=23

You will need to use DataDirect SequeLink Server to configure MS Access as a data source, as described here:

http://www.stylusstudio.com/configure_data_source.html

Hope this helps.

David Foster
Stylus Studio Team

Postnext
Susie ShafferSubject: Populating MS access from XML datafiles
Author: Susie Shaffer
Date: 06 Mar 2006 06:09 PM
Ok, thanks for your response.

Couldn't I also handle it this way.

Access will NOT import attribute-centric XML files. However, Access WILL allow you to import an element-centric XML files.

The Microsoft websites gives an example of creating an attribute-centric file from the sample Northwinds file. It then takes the attribute-centric XML file, applys a style sheet to create an element-centric XML file. It then imports the element-centric XML file into a table.

I have an attribue-centric file that I would like to bring into Access. So I thought, if I create a style sheet, I could create a new element-centric XML file and import it into Access.

That's where stylusstudio comes in. Can I use stylusstudio to create a style sheet for me. I have the source code (an attribue-centric XML file) and it references an xsd file.

Thanks
Postnext
Minollo I.Subject: Populating MS access from XML datafiles
Author: Minollo I.
Date: 06 Mar 2006 08:39 PM
Susie,
you may want to post your "attribute-centric" XML document for specific help; this XSLT will in general convert attributes into child elements for any XML...

<xsl:template match="/">
<xsl:apply-templates/>
</xsl:template>
<xsl:template match="@*">
<xsl:element name="{name()}">
<xsl:value-of select="."/>
</xsl:element>
</xsl:template>
<xsl:template match="*">
<xsl:element name="{name()}">
<xsl:apply-templates select="@*"/>
<xsl:apply-templates/>
</xsl:element>
</xsl:template>
Postnext
Susie ShafferSubject: Populating MS access from XML datafiles
Author: Susie Shaffer
Date: 07 Mar 2006 08:11 AM
OK, I will give your sample a try.

Meanwhile, the file I am trying to change is:

http://nvd.nist.gov/download/nvdcve-modified.xml

Postnext
Minollo I.Subject: Populating MS access from XML datafiles
Author: Minollo I.
Date: 07 Mar 2006 09:12 AM
Taking a quick look at the XML file you attached, I have the impression that you want to control more carefully what and how is stored in your database... which means the way to go is probably what David mentioned yesterday.

Hope this helps,
Minollo
Posttop
McKyle AdamsSubject: Populating MS access from XML datafiles
Author: McKyle Adams
Date: 11 Jun 2006 05:43 PM
Susie,

Did you ever get a response on this that worked? I have the same issue and have yet to figure out how to do this conversion to get the data into Access.

Thanks,

McKyle
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.