<div>
I've &nbsp;tried the examples shown on the website, but they are not working. This could be because I am using Access 2007.
</div>

<div>
They should work in Access 2007, I use these myself in Access 2007. 
 
Why are these not working for you? Any errors? 
 
HTH, 
Daniel
</div>

<div>
The script produces the xml, xsl, xsd, and htm files. When I run the htm file, it should give me the info listed in the XML file. But instead, it tries to open up a new IE Tab but it seems to be going through an endless loop, not showing anything. 
I've added the code that I am using. 
Thanks 

<pre><code class="code-10 nolinks" id="code-8168939">Private Sub ExportRelTables()
 ' Purpose: Exports the Orders table as well as
 ' a number of related database to an XML file.
 ' XSD and XSL files are also created.

 Dim objAD As AdditionalData

 ' Create the AdditionalData object.
 Set objAD = Application.CreateAdditionalData

 ' Add the related tables to the object.
 With objAD
 .Add &quot;Orders Details&quot;
 objAD(&quot;Orders Details&quot;).Add &quot;Orders Details Details&quot;
 .Add &quot;Customers&quot;
 .Add &quot;Shippers&quot;
 .Add &quot;Employees&quot;
 .Add &quot;Products&quot;
 objAD(&quot;Products&quot;).Add &quot;Product Details&quot;
 objAD(&quot;Products&quot;)(&quot;Product Details&quot;).Add _
 &quot;Product Details Details&quot;
 .Add &quot;Suppliers&quot;
 .Add &quot;Categories&quot;
 End With
Application.ExportXML acExportTable, &quot;Orders&quot;, _
 &quot;H:\Orders.xml&quot;, _
 &quot;H:\OrdersSchema.xsd&quot;, _
 &quot;H:\OrdersStyle.xsl&quot;, AdditionalData:=objAD
End Sub
</code></pre>
</div>

<div>
You cant use the OrdersStyle.xsl with the ExportXML() command, the transformation will be done with the TransformXML() command. 
 
HTH, 
Daniel
</div>

<div>
Hi Daniel, 
I am awarding you the points. I am unable to create a working VBA script, but I know it's posible. Instead of using scripts, I am going to do a mail merge with MS Word. The XML code will be in the Word Document and I'll just point the data to the SQL DB. I've tested it and It works. It's not the best solution, but never the less, it works. &quot;Poor Man's Coding&quot; 
 
Thanks for your help, 
Abe
</div>

<div>
VBA is the way to go with this solution.
</div>

<div>
<div class="content wysiwyg-content">
I need to create XML files for every entree in a Access 2007 Database table. The formate of the XML file needs to match the formate of a InfoPath Document template. This InfoPath template Doucment is published to a sharepoint Form Doucment. 
What I am tying to do is to automate the proccess of Creating the InfoPath documents rather than entering all the information into InfoPath manually to create the Documents localy. 
After the Documents are created, they are uploaded to a Form Document library on a Sharepoint Site or, have the InfoPath XML files saved directly to the Library. 
Thank you, 
Abe
</div>
</div>

I need to create XML files for every entree in a Access 2007 Database table. The formate of the XML file needs to match the formate of a InfoPath Document template. This InfoPath template Doucment is published to a sharepoint Form Doucment.
What I am tying to do is to automate the proccess of Creating the InfoPath documents rather than entering all the information into InfoPath manually to create the Documents localy.
After the Documents are created, they are uploaded to a Form Document library on a Sharepoint Site or, have the InfoPath XML files saved directly to the Library.
Thank you,
Abe

Exporting MS Access Date to a InfoPath XML formated file

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft InfoPath is a software application for designing, distributing, filling and submitting electronic forms containing structured data. The product features a WYSIWYG form designer in which the various controls (e.g. textbox, radio button, checkbox) are bound to data, represented separately as a hierarchical tree view of folders and data fields. All the data stored in InfoPath forms are stored in an XML format. Secondary data sources can be built into the form or they can be accessed through an external data connection to SharePoint or a Web service.