On the other hand...

One of the rules of extreme programming was "do the simplest thing that could possibly work."

There is some danger in adding code complexity to anticipate future conditions...

Ain't it nice! You are right, the folks who contribute here do a wonderful and valuable job. Thanks to all!

Sounds like you got it to work with a password protected .mdb.

If Darth's suggestion helped ("quick point, you need 3.51 for Access 97") I gotta show my stupidity and...

Is something preventing you from simply linking to the Access DB as an external linked server? Then you simply work with the Access data as you would after (an unnecessary?)...

Sorry Gail, but I confuse easily. In the code you posted:

SELECT [Code],

[AsofDate],

[MyValue]

FROM (

SELECT [Code],

[AsofDate],

[MyValue],

ROW_NUMBER() OVER (PARTITION BY Code ORDER BY AsofDate...

FWIW: One more vote for using a pull approach instead of a push. Simply create views/procs to select the data required, populate the workbook with those external data sources,...

Thanks Dex, I appreciate your insights.

And, I am now reminded that a promised months ago to post a sample that exhibits the problem I thought I was seeing. I'll tie...

Thanks very much Lowell -- exactly what I needed!

Marios Philippopoulos (8/12/2009)

---

We have a lot of linked servers in our environment, and we (the DBAs) have recently started pushing our developers to create SSIS packages for instance-to-instance data transfers,...

Tank ewe!

This morning (8/4) the spell check seems to be broken again. I hate to admit how much I rely on this capability, but wish it could be fixed for...

Jeff Moden (7/31/2009)

---

Hi Jim,

… How big are these files? I know you said they've all got 5 columns but how many rows do they typical have? Also, how...

I find single user mode too restrictive, in that I cant open other SSMS queries, or run, e.g. SSIS jobs. What I really want (guess I am just selfish)...

Excellent point. The fact that so...

ed (6/12/2009)

---

I realize that now that I am dealing with the bit data type that I can't write a query such as: SELECT COUNT(Active) AS...