"Richard Kerr" <richard.kerr@volteurope.com> wrote in message
news:umWHleCsDHA.2364@TK2MSFTNGP09.phx.gbl...
> Hi all,
> I know this is a common problem but through all of my searches on the
> web; none of the examples work.
>
> The problem is I have a directory on a drive somewhere that contain a
> number of CSV/EXCEL Files. The names and number of these files change
> on a daily basis.
>
> I need a method within DTS to import all of the files into a single
> table?
>
> The format of the files will all match the defintion of the table I want
> to import into, so the real issue is solely about how to look through
> each file and import.
>
> If you've got any working examples that would be much appreciated.
>
> Cheers in advance
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

"Richard Kerr" <richard.kerr@volteurope.com> wrote in message
news:umWHleCsDHA.2364@TK2MSFTNGP09.phx.gbl...
> Hi all,
> I know this is a common problem but through all of my searches on the
> web; none of the examples work.
>
> The problem is I have a directory on a drive somewhere that contain a
> number of CSV/EXCEL Files. The names and number of these files change
> on a daily basis.
>
> I need a method within DTS to import all of the files into a single
> table?
>
> The format of the files will all match the defintion of the table I want
> to import into, so the real issue is solely about how to look through
> each file and import.
>
> If you've got any working examples that would be much appreciated.
>
> Cheers in advance
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!