65.9K
CodeProject is changing. Read more.
Home

Database to XML Exporter

starIcon
emptyStarIcon
starIcon
emptyStarIconemptyStarIconemptyStarIcon

1.14/5 (8 votes)

Jul 19, 2001

viewsIcon

77582

downloadIcon

1714

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.