I think a query might take longer.

When i said that i have a key value in column B, i meant that i have
unique key value, so i would have to have about 14,000 queries in orde
to get all my columns, and i would have to query from 3 text files fo
each iteration, unless of course i missed what you were trying to say

--
Message posted from http://www.ExcelForum.com