>>>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
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing