Hi,

Can someone please help me. I have a directory full
of .txt files and I wish to import the contents and the
filename into a table in SQL2000.

Any links on the web etc...??

Any help will be much appreciated.

Thanks,

Skc

see "importing data" in SQL Server Books Online
The easy way is to use DTS wizard from Enterprise Manager
rightclick on DB you want to import in, and select "all tasks" - "Import
data"

select dataSource - textFile

"skc" <anonymous (AT) discussions (DOT) microsoft.com> píse v diskusním príspevku
news:3f6a01c49005$83a8a3c0$a601280a (AT) phx (DOT) gbl...

I want an automated routine to import all .txt in a
directory and the filename in the table.

Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)

Import all files in a directory (Multi Step)
(http://www.databasejournal.com/featu...le.php/1461661)


"skc" <anonymous (AT) discussions (DOT) microsoft.com> wrote

I want an automated routine to import all .txt in a
directory and the filename in the table.