>>I do spot one error in my code. Inside the loop, I forgot one ')'. Try "append from (lcDir + laFiles(lnX,1)) DELIMITED WITH CHAR , "
>
>lnfiles returns 0 from your code
How many files are in that directory? Is it a network drive? Can you copy these files to a local drive instead?
A while ago I was having some problems with adir, network drive and lots of files. I can not search anymore for details, but it was in October 2006 and I posted here about these problems in case you want to search.
Don't think it applies here, but just throwing the possibility.
If it's not broken, fix it until it is.
My Blog