Q
Problem solve Get help with specific problems with your technologies, process and projects.

How do I convert a database to XML with VB6?

How do I convert a relational database to XML and vice versa using Visual Basic 6?
You will almost certainly find that there are utilities that operate at the ODBC level that will do this for you.

If you are doing it yourself - the "database to XML" conversion just involves picking up a recordset and writing suitable tags around each record and field. Top and tail the whole lot with a single element - say, <RecordSet> and you're done.

On the "XML to database" side, you will need to parse the XML, perhaps with MSXML and then make the necessary database calls to add records to the database.
This was last published in January 2003

Dig Deeper on Development implications of microservices architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchSoftwareQuality

SearchCloudApplications

SearchAWS

TheServerSide.com

SearchWinDevelopment

DevOpsAgenda

Close