Shelmina -- strike through's are just a text formatting option, like bold , italic, type face or font size; they are not part of the data.

So the problem lies with...

Thanks for your suggestions. I'm pretty sure I can't blame Access -- all of the eight tables are from the same Access DB, and the smaller ones are transferred at...

Can you set the named range in the sheet? If you do, the "data sets" available to import will include both the worksheet tabs (suffixed with a "$") and your...

Jeff, when you get that place straightened out, write it all down and publish it as "Tales from the deep Kimchie"; sounds like it would be best seller!

I wished for that ability also (wildcards in [fileName*] but it doesn't seem to be supported.

But you can always start with some token [FileName#SuffixGoesHere#] and do a string replace...

Nope, you...

Before everyone jumps on the "never SELECT *" bandwagon, I'd argue that there are cases where * is both useful and appropriate. One example is a view that provides a...

Nice introduction. I agree it (the database diagram tool) the has some nice features, but it also scared the hell out of me. As I recall, when I decided to...

Not sure that would constitute normal form, but whatever works for you.

My suggestion would have been a two column table with parent and child foreign keys. That...

Andy Lennon (9/30/2008)

---

... our biggest problem is with managers from other departments who go through an entire approval process for new specs, then the day after the changes go live,...

I have, and it is no pleasure...

Don't think it is in a cookie, cause I always need (and always want to) see the last 10. On another note, I don't think it matters which post you...

Perhaps the "group" discussion is something of a red herring. I do not use AD Groups at all (because the group membership is controlled by the IT staff, and...

I'd suggest a single table of parent-child relationships, and a second table, if necessary, translating relationship levels (0,1,...n) into appropriate names for specific product lines. In other words, treat it...

Good for you Steve, another plus for those of us who start out dumb -- we don't have to "dumb down" anything!