Hi Ax:

when I remove the 'On Error Resume Next', you are correct. It is obvious what was missing. After fixing the name however (and the field name in the loop) I now get the message: "Run-Time Error 3265 Item cannot be found in the collection corresponding to the requested name or ordinal".

I would have expected the table "ADD0DATA" would have been created by the "Select" statement earlier, but no table exists.

The problem I have with "TransferText" is that I would need to build an ImportSpecification. My preference is the Schema.ini, since the field layout and field length for each of the 15 or so tables in the collection may change from time to time, and I do want to automate the procedure as much as possible. Now if someone could help me automate the creation of the Import Specifications from an already-created table, that would solve the problem.

Thanks, and back to you.
jnlw09