>>>>You must use the specific file name. You can use ADIR to get a list of files then loop though the array.
>>>>
>>>>
>>>>>In my directory j:\interlinkhayes are a number of csv files all of the same format delimited with commas
>>>>>
>>>>>If I append just 1 file as follows APPEND FROM j:\interlinkhayes\INT12345.csv DELIMITED WITH CHAR , I have no problems
>>>>>
>>>>>But if I try APPEND FROM j:\interlinkhayes\INT*.csv DELIMITED WITH CHAR , I get errors
>>>>>
>>>>>What is the simplest code for appending multiple files with a skeleton INT*.CSV
>>>
>>>Thanks
>>>
>>>Can you show me the code to get a list of all the files
>>>
>>>Much appreciated
>>
>>
>>lcDir = ' j:\interlinkhayes\'
>>lcSkeleton = 'int*.csv'
>>lnFiles = adir(laFiles, lcDir + lcSkeleton)
>>for lnX = 1 to lnFiles
>> append from (lcDir + laFiles(lnX,1) ...
>>Endfor
>
>
>
>But this code appears to work - am I correct?
>
>gnumber = ADIR(gaDatabase, '*.csv') && Create array
>
>gnumber=1
>FOR x=1 to gnumber
>store gadatabase(x,1) TO muc
>
>muc="j:\interlinkhayes\"+muc
>WAIT WINDOW muc
>SELECT hayes
>APPEND FROM &muc DELIMITED WITH CHAR ,
>
>next
To be honest, I have problems understanding your code. My code DOES work, once you have fixed your typos. And stay away from macros, &, as in &muc. Use (muc) instead, it's safer and faster.