Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB 2005 > Visual Basic 2005 Basics
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Visual Basic 2005 Basics If you are new to Visual Basic programming with version 2005, this is the place to start your questions. For questions about the book: Beginning Visual Basic 2005 by Thearon Willis and Bryan Newsome, ISBN: 0-7645-7401-9 please, use this forum instead.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Visual Basic 2005 Basics section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old November 24th, 2005, 09:26 AM
Registered User
 
Join Date: Nov 2005
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default export data from Access to XML file with VB2005

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


Reply With Quote
  #2 (permalink)  
Old November 24th, 2005, 01:57 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , .
Posts: 453
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via AIM to Ankur_Verma Send a message via MSN to Ankur_Verma
Default

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
Reply With Quote
  #3 (permalink)  
Old November 25th, 2005, 09:41 AM
Registered User
 
Join Date: Nov 2005
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I export an access db table to xml? solos VB How-To 4 April 3rd, 2007 11:56 PM
How to export the data to XML file format? mbshankar Pro VB 6 2 April 3rd, 2007 12:22 PM
scheduled export to XML file jjhm93 SQL Server 2005 2 December 15th, 2006 02:28 PM
DTS Package Export Data to XML Problem kwilliams SQL Server DTS 1 January 3rd, 2006 02:22 PM
How to Export SQL Server Table to XML file??? bekim XML 1 October 4th, 2004 03:52 AM



All times are GMT -4. The time now is 07:03 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.