Get files in different folder using sql

Giganews Newsgroups
Subject: Get files in different folder using sql
Posted by:  ntuyen…@yahoo.com
Date: 9 Aug 2006

Hi All,

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
using bcp.

Example files structure dir:
\xyz\123\abc\text1.txt
\xyz\123\abc\text2.txt
\zyz\123\999\text2.txt

bcp "dabase" in \xyz\123\abc\text1.txt -c -S"servername' -Usa
-Ppassword -T".

is there away to loop througth each dir, get the files, excecute the
bcp, then go to next folder.

Please help. Thanks in advance.

Ted Lee

Replies