Quite new to VB.net and looking for advice on how to process large XML files. The file I have is about 600mb but could be larger and I want to load it into a Access database.
Using the import feature of Access doesn't load the data correctly, for instance I have
I'm quite new to VB.net and now seem to be jumping into the fire by trying to process an XML file into an Access Database.
Here is what I have
If I run code
Dim ds As New DataSet("XMLDataSet")
Dim xmlDocument As New XmlDocument
xmlDocument = New XmlDocument...
Thanks for the reply.
Actually I downloaded the 101 examples a while back. Within the sample code there is 1 ADO 2.6 example and based around. Although I had looked at it several times before I reviewed it again.
This may be where my knowledge of SQL and ADO.Net let's me down, but he update...
I'm a little short on replies so I'll try to quantify my question.
With the above code I create an Email address which I then want to save to the same Excel Spreadsheet.
Ideally I don't want to update each row.
So is there a way to save the whole DataSet in one go?
Any example / pointer...
Still trying to complete my first VB/ADO.Net piece of code. The final piece of help I need is how to write out my DataSet which I have updated back to the original Excel spreadsheet or to a new spreadsheet?
Below is my code..
Many thanks RibTime
Private Sub Button1_Click(ByVal sender As...
I'm very new at VB and trying to lean by writing a small program to read an excel spreadsheet and then add/update some of the cells. As you can see below I have used ADO.Net and have loaded my data into a DataSet.
Having searched round the forums and web for examples I seem have drawn a blank...