http://support.microsoft.com/default.aspx?scid=kb;en-us;899599

Check out this article if you are still having the issue. I am facing a similar problem and am likely appying the fix tonight. Hope that article helps the...

That works too and is a lot less code. It is not as intuitive to me so I’ll have to spend some time with it before I really get it.

...

Looks like the easiest solution is to add a linked server. This should have been obvious from the start but…I played with the opendatsource and openrowset as well. These solutions...

I am attempting to do this as a final step in an import and scrub process in SQL Server. The Access database, I am thinking, will be used to log...