trying to save Access dataset as XML file

[Mary McRae]

I'm creating a small test application where I simply take the contents of an
Access database and write it to an XML file (using Access' default XML).
Once the file is written, I then run it through a transform which basically
merges the contents of the database with a Word XML document instance. The
final file is then saved and returned to the requestor.

I've been pouring over examples, and can't find anything that is exactly
what I'm looking for ... can anyone point me to some samples? I've done
everything manually - that is, export the table and save as XML, run the
transform and create the result file. I've got the transform coded and it
works fine; it's just the database piece I'm missing. I've gotten this far
(without encountering any errors at runtime):

Dim connectString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & thisDBName

Dim myDA As OleDbDataAdapter = New OleDbDataAdapter("SELECT A, B, C FROM
TableX", _
connectString)

Thanks for any and all help!

[William Ryan eMVP]

then call dataadapter.Fill(ds);

ds.WriteXML(@"..\someData.xml");

That will output the query resulst into XML . You can get the dataset back
with ReadXML

I can't really understand the missing chunk but I'm guessing this is it. If
not,let me know
"Mary McRae" <ma*******@sprintpcs.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

I'm creating a small test application where I simply take the contents of an Access database and write it to an XML file (using Access' default XML).
Once the file is written, I then run it through a transform which basically merges the contents of the database with a Word XML document instance. The
final file is then saved and returned to the requestor.

I've been pouring over examples, and can't find anything that is exactly
what I'm looking for ... can anyone point me to some samples? I've done
everything manually - that is, export the table and save as XML, run the
transform and create the result file. I've got the transform coded and it
works fine; it's just the database piece I'm missing. I've gotten this far
(without encountering any errors at runtime):

Dim connectString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & thisDBName

Dim myDA As OleDbDataAdapter = New OleDbDataAdapter("SELECT A, B, C FROM
TableX", _
connectString)

Thanks for any and all help!

[Mary McRae]

Thanks for the very quick response, that worked great!

What little time I've spent actually writing MS code is around Office 2003
smart documents; so the vast majority of this stuff is very new to me.

Is there a good book you can recommend on doing VB.NET programming against
Access? I spent a good hour at the local B&N and didn't find much of
anything that looked useful. Of course I didn't know if I really needed an
ASP.NET or ADO.NET or some other book ...

Thanks again!

Mary

[Cor Ligthert]

Mary,

You can try this, in my opinion much better than any book.

http://msdn.microsoft.com/vbasic/vbrkit/default.aspx

And if you have problems installing it

http://msdn.microsoft.com/vbasic/vbr...q/#installvdir

I hope this helps a little bit?

Cor

[Mary McRae]

Thanks, Cor ... I got one of those CDs as part of the VB.NET World Tour grab
bag a couple of weeks ago (along with Whidbey). I'll have to break the seal
and give it a look.

Mary