They need for me to import a text file into an Access file - no problem. Then
import another text file into another Access file and compare records between
them. Non dups records in second file need to be appended to the first file.
Duplicates are defined as the 5 leftmost chr of the first field concatenated
to 5 leftmost chr of 4th field concatenated to the 3 leftmost chr of the 7th
field - Problem. Also, there may be 3 or more text files that need to be
appended to first file.
Tried UNION to put all non dups together - worked but then failed when I
tried using the LEFT$ command to select just the 13 concatenated characters.
Tried a delete query using LEFT$ for each field. Wouldn't accept syntax.
Please help us Obi Won Kanobi, er, fellow users. You are our only hope.