Compare columns in two files 2

[vbobby]

I need to compare columns(not all) in two files. what is the solution for this? can u read a file into a ADO recordset? How?

 

[RonVaught]

Not sure how to answer all of your question. Populating an ADO Recordset with data from a text file is possible. After instantiating a Recordset you can append fields as shown below


Set rs = New ADODB.Recordset

With rs
.Fields.Append "Value1", adVarChar, 100
.Fields.Append "Value2", adVarChar, 100
.Open
End With


After you have fields in your (disconnected Recordset) you can start dropping off data in the Recordset. I envision this bit of code inside a loop that’s reading your text file(s)

With rs
.AddNew
!Value1 = "Data From Text File1"
!Value2 = 'Data From Text File2"
.Update
End With

Does this help?

 

[vbobby]

Thanks Ron that really helped.