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.

Dig Deeper on Topics Archive

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.