create an xml file

[csharpcoder]

I created an VB.NET form to create an xml file, however, it needed to be done in VBA so it would work from an Access form.

Due to I can't copy and paiste my vb.net code to access, how can I create my XML file from MS Access?

I need to call a query within my access db, and take those results and generate an xml file something like this

<Report>
<salesdate></salesdate>
<salesman>
<name></name>
<date></date>
</salesman>
</Report>

and so on, how can I accomplish this using VBA within ms access 07

 

[Uncle Gizmo]

VB.Net Code should work in Access, you will need to modify it though.

 

[Uncle Gizmo]

You could also consider turning your VB.net code into a dll file and calling that from your access application.

 

[Uncle Gizmo]

There is also some method of manipulating Microsoft Office applications from VB.Net. I can’t recall any details but it may be worth looking into.

 

[csharpcoder]

the thing i'm running into is the XMLTextWriter i'm using in the vb.net form, what would that object be in VBA? R

 

[Uncle Gizmo]

I don't think XMLTextWriter is available in MS Access....

You may find this Link useful:
http://msdn.microsoft.com/en-us/library/bb237973(office.12).aspx

And these Chapters....

Hack 63. Import Varied XML Data into Access
Hack 64. Export XML Data Sanely
Hack 65. Break Through VBA's Transformation Barrier

In the Book: Access Hacks

 

[Uncle Gizmo]

You may find this useful:
http://www.databasejournal.com/features/msaccess/article.php/3739696/In-the-cloud--Using-Microsoft-Access-to-query-and-update-Web-sites.htm

 

[darbid]

If you have made some VB.Net code then that will never work by just copying and pasting into VBA - The language is different and Access cannot read the .NET libraries it relies on.

You options there would be to expose certain methods or functions of the VB.net code and make it into a COM compliant .dll which could be registered and then used by Access and VBA.