Hi everyone,

At the moment I'm working on a small application to learn Visual Basic 2005. I have no experience with previous versions of Visual Basic. I'm using an Access database.

My problem at the moment is exporting to XML. On the internet I find all kind of tutorials on this subject for VB6, but not VB2005.
In a VB6 tutorial there's the following line:

Dim rs As ADODB.Recordset

But VB2005 gives an error because ADODB.Recordset is not defined.

Can anyone help me? Give me a link to a website which explains how you can export data to XML in VB2005, or give me information about my recordset problem.

All help is appreciated. If you need more info, let me know.

Kind regards,

Lars

U can export access data to XML without having to write any code
http://office.microsoft.com/en-us/as...345611033.aspx

However if you do wanna do it though your program, I would say, in .NET ADO.NET is the most natural way to go when you are dealing with Databases
http://msdn.microsoft.com/library/de...withadonet.asp


With .NET you would be using DataSets instead of Recordsets
http://msdn.microsoft.com/library/de...ngdatasets.asp


And finally for help on writing a DataSet as XML
http://msdn.microsoft.com/library/de...tasetasxml.asp

Regards
Ankur Verma

Wow, thank you for your quick reply!

Yes, I need to do it with code. It's an assignment for school, where I have to write an application which has the option to export all the data from the database.

I'm gonna take a look at your links now. Thanks a lot!

Lars