Hi Ken,
I tried what you said and it is still bombing. Any more
ideas? What imports should I be using?
I chose Embed Schema in exported XML document when
exporting the table from MSAccess.
Thanks!
Bob
PS Here is the code and Error
++++++++++++++++++++++++++++++++++++
Public Class Form1
Inherits System.Windows.Forms.Form
#Region " Windows Form Designer generated code "
Private Sub Button1_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Button1.Click
Dim myDS As DataSet = New DataSet
'myDS.ReadXml("MyAccessTableExportedtoXML.xml",
XmlReadMode.ReadSchema)
myDS.ReadXml("MyAccessTableExportedtoXML.xml")
End Sub
End Class
===ERROR=================================
An unhandled exception of type 'System.ArgumentException'
occurred in system.data.dll
Additional information: The schema namespace is invalid.
Please use this one instead:
http://www.w3.org/2001/XMLSchema.
==========================================
-----Original Message-----
Hi,
You are only trying to read in the table
structure. Try thisinstead.
myDS.ReadXml("MyAccessTableExportedtoXML.xml")
Ken
-----------
"BobAchgill" <an*******@discussions.microsoft.com> wrote
in messagenews:0d****************************@phx.gbl...
I am trying to read in a xml file that I exported from my
MSAccess table using the following lines of code but it
bombs. Is this the right code? Is there a way to get a
clean export from Access so the XML file will read in OK
into a VB .Net Form dataset?
===============================
Private Sub Form1_Load(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles MyBase.Load
Dim myDS As DataSet = New DataSet
myDS.ReadXml
("MyAccessTableExportedtoXML.xml", XmlReadMode.
ReadSchema)
End Sub
==============================
.