sqlzealot-81,

Thank you. That worked perfectly. 33 rows deleted, as expected.

Ian,

That worked perfectly. I was very close to the answer but was making it overly complicated.

I kept trying to use INNER JOIN on the tables instead of using...

Sorry, I meant to say "I've been going about this the wrong way.

Which brings me to an off-topic question. If you want to go back and edit a post,...

Guys,

It suddenly dawned on me that perhaps I'm not going about this the right way (Ian's answer made me think of this). I don't want to update an...

Well, not to dredge up an old topic but this fits my question perfectly. There was never a resolution to the OP's original question posted so I thought I'd reuse...

Well, Guys..

I appreciate the responses but I think it's going to take a really custom solution or (more likely) human intervention.

This is, of course, a variable length field. There...

Jshahan,

Well, the table is created but no records are imported. But just you saying that made me look at the .CSV file very closely

and at the first row number...

Thanks, Jeff.

That's what I figured.

Out of curiosity, does it work as advertised in say, the Developer or Enterprise editions?

What a stupid little nicety to disable in the free...

Yes, I think you're correct. I was unable to even copy the file unless my instance of the database was shut down (my computer is the "gateway", so to speak)....

Lowell,

Thank you very much for your reply. Yes, the situation is a little odd here.

I do know that the database is backed up daily. However, I failed to...