>The COPY FILE command does not seem to work if the destination folder deos not exist. For example if I use the command
>
> COPY FILE 'C:\X\Y\A.*' TO 'A:\X\Y\A.*'
>
>if either the folder "X" or the sub-folder "Y" do not exist. What is the best way of check that the destination folders exist and to create them if the do not?
>
>TIA
TRY
MD A:\X\Y
CATCH
ENDTRY
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.