>aha. That looks like gold dust.
>
>One problem (well - probably thousands if I go that route, but one immediately hit me)
>
>Microsoft's own guide to bulk inserts (which is somewhat less useful in about 20 pages than your own single page but we'll let that pass!) makes mention of the limitation that only users with sysadmin rights can use the bulk insert method.
>
>As the point of my app is to let thousands of users upload their own keys to the database, and, obviously, we can't allow such users sysadmin rights, it would seem that the bulk insert method is not going to be open to me. Unless of course you know of a way around that problem.
>
>If I understand the microsoft limitations correctly, I will still be able to make use of your code for related purposes but not for ordinary users to upload their keys.

A way around :) Not a clear one but might be creating a service that runs with a trusted account (sysadmin,bulkadmin) and checks for txt files ready to be uploaded. No sample as I didn't even done or tested, off the top of my head.

OpenRowset is the one that looks promising to me. Combined with insert into/select or insert into/exec it might work fast. Unfortunately couldn't locate my own samples right now :(

There is also SQLDMO Bulkcopy object and I don't know if that needs sysadmin/bulkadmin role (it's good to be a sysadmin:)

Thousands of users ? and each with thousands of recs upload or few per user ? If the latter than conventional ways might be enough. A very busy server you'll have I think :)
Cetin