Compare data in vb

The first place to start is to open the database in access, create a query that searchs for those specific entries (Bob, heathrow, america). Once you have a query that returns the records that you would expect based on those items, then open the query in SQL mode. Copy the SQL and move it to a VB String. Remember that any quote marks in your SQL statement will have to be doubled when you assign it to the string variable. Example:
SELECT * FROM tblReservation WHERE [Airport] = "heathrow" And [Destination] = "america" And [FirstName] ="Bob";
...becomes
Dim strSQL As String
strSQL = "SELECT * FROM tblReservation WHERE [Airport] = ""heathrow"" And [Destination] = ""america"" And [FirstName] =""Bob"";"

Now change the SQL to replace the items you entered from access (Bob, heathrow, america) into variables from your program Like this:
strSQL = "SELECT * FROM tblReservation WHERE [Airport] = """ & strAriport & """ And [Destination] = """ & strDestination & """ And [FirstName] =""" & strFirstName & """;"

Now when you read your file you can set the variables to the values you just read in and use the assignment statement above to create the needed SQL statement. Now all you have to do is open a connection to your database and open a recordset object using the SQL statement that you created above.