I don't think i could have used the import feature since i will be grabing the file when the user clicks a refresh button, but if you can invoke this in code how?
And actually the text file is really an XML file (hey i was in a hurry when writing for help).
What i was trying to do was basically take the xml file and load into a treeview control. The problem was that the xml stream/file was not in the order i needed. So instead of trying to sort the xml as i populate the treeview i wanted to load the xml into a recordset and sort it then populate the treeview. I figured i would create a recordset and then use the fields.append method to add fields and then i would add the xml data to that recordset. I have never used a recordset in this manner, usually i do the rs.open blahblahblha and that populates the recordset with the data for me.
Anyway, here are the issue i ran into and the solutions in case anyone else ever needs to do soemthing like this:
1) I couldn't get it to let me add fields to the rs because the object was not SET. but i didn't know what to set it to since i didn't really want to set it to a querie or SQL statement. Finally my brother suggested to try
"Set rs = new recordset"
That line allowed me to use the rs.fields.append method to make the structure of the rs.
2) Then i couldn't add any data (using the add method) to the darn recordset because it was not open! So after scouring the net i found an example where they set the rs.open but used a bogus datasource. It worked and then i was able to add records to the rs.