p.s. Don't forget to close the spreadsheet after you save it or you WILL get an access error... 😉

No, no... it's much easier than any of that. This is a common problem and DTS frequently messes up imports especially if there are some merged cells above the...

Ok... here's the code that proves what the problem is... it's not my code, but I forget the name of the good fellow that wrote it for me as a...

Basically it is a proprietary SP provided by a SQL based web application for the purpose of generating unique integer based row IDs. It does several things including calling other...

Thanks for the feedback, but to be sure... cursors are never an option for me. Maybe the occasional WHILE loop to act as a control for managing "dips" to...

Bottom line, sometimes it's just like magic to make the code work Not to mention the ohs and ahs from the staff who were just going to open the...

It was in 2k... Heh... I'm thinking that there's a hidden "bookmark" that didn't show up in the EP. But, correct, it does show that just because an index...

Thanks for the high compliment, Dionisis :blush:

FP = Farrukh? You got two logins?

You should wait forever for that... it's just another way to screw up dates and times.

karthikeyan (12/20/2007)

---

Jeff,

Really i am wondering about your skill.

Can you explain me your two different queries in detailed ?Also,

1. What do you mean by @Delim+Remarks+@Delim ?

i.e...

Sushila! Haven't run into any of your posts in quite a while! So very happy that you're still part of the "community" and very happy to "see" you...

DonaldW (12/20/2007)

---

GilaMonster (12/19/2007)

---

Jeff Moden (12/19/2007)

---

I didn't know how long it originally took and, like the bumble bee who doesn't know it's not supposed to be able to fly, I rewrote...

You bet... let me know how it works out for you. And thanks for the feedback.

Actually, those are pretty good links... Thanks, Steve.