Test .TXT file data

[basanth27]

yes. The first step maybe a bit manual(can be automated too, to trial out..). Import your .txt file into a excel sheet with the correct delimiters.

1. Datatable.Import ( Import the excel sheet on to the datatable)
2. CreateObject("ADODB.Connection") and then Recordset object - Use this to retrieve values you require from the DB using SQL queries.
3. Datatable.Value - Fetch values from Datatable.
4. If Then Else or any other appropriate logical loop to compare values fetched from DB and the values from Datatable.

I have supplied the keywords and the logic of how you have to do it. Pursue further my friend...