|Subject:||Get files in different folder using sql|
|Date:||9 Aug 2006|
I have a multiple files, but they are store in different directory on
the server. I want open those files and insert it into the database
Example files structure dir:
bcp "dabase" in \xyz\123\abc\text1.txt -c -S"servername' -Usa
is there away to loop througth each dir, get the files, excecute the
bcp, then go to next folder.
Please help. Thanks in advance.