thanks for the fast replies. I too find the difference in speed a bit shocking. I have change my code back to DAO (quite easy in this case), so here is the DAO code I am using. I just swap in the ado object when I make the transition. I set up the ADO during design time to map to my created System DSN and table name.

'....Code to read the file

With dataTmpPhone.Recordset
.AddNew
!apptDate = apptDate
!apptTime = apptTime
!doctorName = doctorName
!patientfName = patientfName
!patientlName = patientlName
!patientNo = patientNo
!officeName = office
!miscDate = miscDate
!notes = notes
!misc1 = misc1
!misc2 = misc2
.Update
End With

....Loop back and do it again

I put some debug printing statements in trying to figure out the problem and it finally came down to the ADO. Like I said I am a Java programmer trying to learn VB so I could be doing everything wrong. The other code in this loop doesn't appear to affect speed all that much ( I commented it out to test).

Thanks again.

Kevin