Click here to Skip to main content
Licence 
First Posted 18 Jul 2001
Views 65,183
Bookmarked 27 times

Database to XML Exporter

By | 2 Aug 2001 | Article
Learn how to export database fields to XML document
 
Part of The SQL Zone sponsored by
See Also

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
<FONT color=#0000ff>#import</FONT> "C:\Program Files\Common Files\System\ado\msado15.dll" \
no_namespace \
rename( "EOF", "adoEOF" )

<FONT color=#0000ff>#import</FONT> "c:\winnt\system32\msxml3.dll" named_guids raw_interfaces_only
<FONT color=#0000ff>using namespace MSXML2;</FONT>

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

About the Author

Orkun GEDiK

Software Developer (Senior)
ASTRON
Turkey Turkey

Member

I'm working at Yasar Holding IT department as senior SAP R/3 BASIS and Development Consultant and system integrator. I have experience on C/C++ for 6 years. Implementing and inviting new technologies is most biggest part of my life. Object oriented paradigm is a philosophy of my vision.

Sign Up to vote   Poor Excellent
Add a reason or comment to your vote: x
Votes of 3 or less require a comment

Comments and Discussions

 
You must Sign In to use this message board. (secure sign-in)
 
Search this forum  
 FAQ
    Noise  Layout  Per page   
  Refresh
GeneralMemory management lacks PinsussAydin Bakir0:17 22 Jul '02  
GeneralRe: Memory management lacks PinmemberAhmet Orkun GEDiK18:58 29 Jul '02  
GeneralError.. 'IXMLDocument' : ambigous symbol PinmemberNyrup20:01 18 Jun '02  
QuestionWhere is code? PinmemberKoundinya20:12 8 Jan '02  
GeneralUse _Recordset Save Method PinmemberRashid Thadha22:31 19 Jul '01  
GeneralRe: Use _Recordset Save Methid PinmemberAhmet Orkun GEDiK2:56 20 Jul '01  
GeneralRe: Use _Recordset Save Methid PinmemberNick Henson5:07 2 Aug '01  

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Mobile
Web01 | 2.5.120517.1 | Last Updated 3 Aug 2001
Article Copyright 2001 by Orkun GEDiK
Everything else Copyright © CodeProject, 1999-2012
Terms of Use
Layout: fixed | fluid