Heh... "Flat file cleanup on aisle 5"!

Are you all set, Kirk? Did Mark's post do what you needed (looks like it but thougt I'd double check)?

No, no... it won't fail if the IGNORE DUPLICATES option is turned on for the unique index. It will just give a warning that at least one duplicate was...

You have no error detection code and no rollback code... and SET XACTABORT has not been turned on to make up for it...

... so why do you need a transaction...

I've seen requests like this before and they always puzzle me... it would appear that the name should be the primary key in this case. Yet, you have more...

Not sure what you mean... how?

If you do it right, more than you can possibly imagine...

The following URL has a lot of good information about Excel spreadsheets and ADODB... perhaps it'll have what you're looking for...

http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

Also, not sure why you'd bother pinning it... it will certainly fit in cache.

17GB seems a bit large even if it's a Terabyte instance... if folks are using triangular joins, cursors for large record sets, temp tables for large record sets, views of...

First, nice idea... hadn't thought about doing it that way. Great way to import...

Sergiy (1/14/2008)

---

All of you are wrong.

Using "," as delimites is an error waiting to happen.

mdjtlj, ask you supplier to build a test file containing '19" Monitor'.

Then try to process that...

I could be wrong, but I don't think there is...

Alter table won't support a 4 part naming convention, anyway... object functions and Alter table all support 3 part naming conventions... why not use them?

If you have 20 columns in table A, and you try to list all 20 columns in the presence of a COUNT, then you must list all 20 columns in...

Shoot... I hope I didn't just help someone do their homework without them trying themselves, first...