Hi Carol,

Try this link:
http://www.extremeexperts.com/SQL/Tips/GetDirectoryInfo.aspx

Trevor

----- Original Message -----
From: Carol Green <mssqldba-ezmlmshield-
x49337922.[Email address protected]
Date: Friday, March 31, 2006 3:28 am
Subject: Create table of files
To: LazyDBA Discussion <[Email address protected]

> Hello all,
>
> I would like to write the contents of a directory into a table as
> follows
>
> Filename
> File1.txt
> File2.txt
> File3.txt
>
> Does anyone have a script that would do this?
>
> Carol.
>
> -------------------------------------------------------------------
> --
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website :
> http://www.LazyDBA.com To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
>
>
> This email and any files transmitted within it are private and
> confidential.
> If you are not the intended recipient, this email and any
> attachments within it have been transmitted to you in error.
> You are prohibited from using, copying, distributing or otherwise
> using the information contained within this email.
> Nothing in this email message amounts to a contractual or legal
> commitment on the part of Optilan unless confirmed by a
> communication signed on behalf of the company.
> Any email cannot be guaranteed to be secure, error free or free
> from viruses. Although every possible care is taken by Optilan,
> Optilan does not accept any liability whatsoever for any loss or
> damage which may be caused as a result of the transmission of this
> message by email.
>
>
>
> -------------------------------------------------------------------
> --
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>

MS Sql Server LazyDBA home page