It turns out I did not show enough of my code in the first post. The process was actually croaking in another section altogether. There is another spot that I create an XML using FSO. I converted it...

PrivateSub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) HandlesMyBase.Load
Dim conn As New ADODB.Connection()
Dim rs As New ADODB.Recordset()
Dim connStr, sSQL As String...

something like SELECT "firstname" as FirstName, "lastname" as LastName INTO newTable;

or if you are putting data in the new table from another then SELECT "firstname" as FirstName, "lastname" as...

I am upgrading a vb 6.0 app to .net and I'm having trouble moving a file. The app retrieves info from an XML. When it's done I try to move the .xml file to a history folder and I'm getting an...

IF LEN(Datetimepicker1.value.dayofweek.toString)=0 THEN
dates_chosen.text = datetimepicker1.value.dayofweek.toString
ELSE
dates_chosen.text = DATES_CHOSEN.TEXT +", " +...