Search results for query: *

Hi there 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 <owner_data>...

All sorted now. Asked the same question on the other vb.net site and posted some code extracts there if anyone has the same problem. RibTime

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...

Top man... Many thanks again. I've spent quite a lot of time looking into this but suspect I have some code downloaded / documentation giving me the answer. Cheers RibTime

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...

Paszt Many thanks for your reply and advice, I shall have a look at my code very soon! Thanks again RibTime

After posting this thread I realise, or realize for the US, that it should be posted somwhere else. Anyway 16 views and no answers! RibTime

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...