Dump whole dataset to a new access table

[Marcolino]

Hi all,
I have an application that needs to import XML files into Database.
This XML file was generated by this:

Private Sub Button1_Click(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles Button1.Click
Dim cmdXML As OleDb.OleDbComm and
Dim DScmdXML As OleDb.OleDbData Adapter
Dim DSXML As New DataSet()

Dim sqlXML As String = "SELECT * FROM List_Piante"
cmdXML = New OleDb.OleDbComm and(sqlXML, conn)
DScmdXML = New OleDb.OleDbData Adapter(cmdXML)
DScmdXML.Fill(D SXML, "List_Piant e")
DSXML.WriteXml( "Piante.xml ", XmlWriteMode.Wr iteSchema)
Dim xmlSW2 As System.IO.Strea mWriter = New
System.IO.Strea mWriter("c:\Pia nte.xml")
DSXML.WriteXml( xmlSW2, XmlWriteMode.Wr iteSchema)
xmlSW2.Flush()
xmlSW2.Close()

End Sub

I need to import this XML file into a NEW created ms-access table, but
i don't know how, and i cannot find any helpful suggestion on google.

Many Thanks

[Michel Posseth [MCP]]

Well i guess you can do 2 things

1 . really create a database from scratch , you can do this with ADOX (
Com interop in .Net ) as there is no managed libraray availlable wich can do
this

OR

2. Create a empty database , with empty tables in a Access database ( repair
and compress it after doing so in Access ) and now add this as a resource
in your executable so instead of creating a new database , your app simply
copies a empty database from it`s resource and fills this with the data
contained in the XML files ( no need for COM interop , much faster )

I have done option 2 numerous times and can show you an example if you want

Michel

"Marcolino" <ma************ @gmail.comschre ef in bericht
news:41******** *************** ***********@d45 g2000hsc.google groups.com...

Hi all,
I have an application that needs to import XML files into Database.
This XML file was generated by this:

Private Sub Button1_Click(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles Button1.Click
Dim cmdXML As OleDb.OleDbComm and
Dim DScmdXML As OleDb.OleDbData Adapter
Dim DSXML As New DataSet()

Dim sqlXML As String = "SELECT * FROM List_Piante"
cmdXML = New OleDb.OleDbComm and(sqlXML, conn)
DScmdXML = New OleDb.OleDbData Adapter(cmdXML)
DScmdXML.Fill(D SXML, "List_Piant e")
DSXML.WriteXml( "Piante.xml ", XmlWriteMode.Wr iteSchema)
Dim xmlSW2 As System.IO.Strea mWriter = New
System.IO.Strea mWriter("c:\Pia nte.xml")
DSXML.WriteXml( xmlSW2, XmlWriteMode.Wr iteSchema)
xmlSW2.Flush()
xmlSW2.Close()

End Sub

I need to import this XML file into a NEW created ms-access table, but
i don't know how, and i cannot find any helpful suggestion on google.

Many Thanks

[Marcolino]

On 23 Mar, 09:36, "Michel Posseth [MCP]" <M...@posseth.c omwrote:

Well i guess you can do 2 things

1 . really create a database from scratch , you can do this with ADOX * (
Com interop in .Net ) as there is no managed libraray availlable wich can do
this

OR

2. Create a empty database , with empty tables in a Access database ( repair
and compress it after doing so in Access ) *and now add this as a resource
in your executable * so instead of creating a new database , your app simply
copies a empty database from it`s resource and fills this with the data
contained in the XML files ( no need for COM interop , much faster )

I have done option 2 numerous times and can show you an example if you want

Michel

"Marcolino" <marco.pozzu... @gmail.comschre ef in berichtnews:41* *************** *************** ***@d45g2000hsc .googlegroups.c om...

Hi all,
I have an application that needs to import XML files into Database.
This XML file was generated by this:

Private Sub Button1_Click(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles Button1.Click
* * * *Dim cmdXML As OleDb.OleDbComm and
* * * *Dim DScmdXML As OleDb.OleDbData Adapter
* * * *Dim DSXML As New DataSet()

* * * *Dim sqlXML As String = "SELECT * FROM List_Piante"
* * * *cmdXML = New OleDb.OleDbComm and(sqlXML, conn)
* * * *DScmdXML = New OleDb.OleDbData Adapter(cmdXML)
* * * *DScmdXML.Fill( DSXML, "List_Piant e")
* * * *DSXML.WriteXml ("Piante.xml ", XmlWriteMode.Wr iteSchema)
* * * *Dim xmlSW2 As System.IO.Strea mWriter = New
System.IO.Strea mWriter("c:\Pia nte.xml")
* * * *DSXML.WriteXml (xmlSW2, XmlWriteMode.Wr iteSchema)
* * * *xmlSW2.Flush()
* * * *xmlSW2.Close()

End Sub

I need to import this XML file into a NEW created ms-access table, but
i don't know how, and i cannot find any helpful suggestion on google.

Many Thanks- Nascondi testo tra virgolette -

- Mostra testo tra virgolette -

MIchel,
very thanks for your help.
can you provide me the example for option 2?

Thanks