Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles
(untagged)

Database to XML Exporter

0.00/5 (No votes)
2 Aug 2001 1  
Learn how to export database fields to XML document

Screenshot

Introduction

This code exports database fields to XML document. You can use this code for data export processes. I used Microsoft Visual C++ 6.0 for coding. Let me give some information about code;

I used db2xml.mdb as a sample database. Database has one table and that table has two fields, named Name, Surname. I used ADO 1.5 for connecting to database and again i used MSXML 3.0 for exporting data from database. Maybe you should change some code in stdafx.h. Because it has two hard coded #import directives like that;

// Import DLL File

#import "C:\Program Files\Common Files\System\ado\msado15.dll" \
no_namespace \
rename( "EOF", "adoEOF" )

#import "c:\winnt\system32\msxml3.dll" named_guids raw_interfaces_only
using namespace MSXML2;

Last note; copy db2xml.mdb and db2xml.exe files into same directory.

What You Need:

Have an installed MDAC and MSXML 3.0

Lets meet at new projects, i hope.

Please send any comments or bug reports to me via email.

I'm VC++ Programmer.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here