Hi Andy,

If you're still up for doing this, I could really use your guidance!

Either way, thank you. 

KS.

Thanks Andy, the ideas are appreciated, although I'd hoped for a click-by-click explanation, I'm grateful for any assistance.

Also, I've not used VB or shell commands before, so the venture is...

Cheers Butch (Pulp Fiction fan, I presume?)

I dropped the 'where' clause, and it returns the entire table - as it should.

Any idea how to case-desensitize Access?  This is a personal...

Thanks!

KS

Manny,

If you could give me a rough overview of how you can import schema in DTS, that'd be grand!

KS.

Hi Steve, thanks for the replies, just a few points thereon:

1 Does SQL Server need to be specifically configured for dynamic queries?

2) Would SQL Server generate the script file, or...