One approach to this in Excel is with parameters. Create a DSN and link to the database, then in the query builder use SQL and enter something like this:

SELECT...

Re: Alternative is to have them load personal edition and do it there, at least then it's their disk space.

In terms of logistics this is not a bad alternative, the...

I have the same interest. We have a data warehouse that has an ever growing number of tables. Our power users rely on documentation in Word to find...

If IIS is available you might consider a pull rather than push solution.

Let the user hit a web page that connects from an ASP page to the SQL Server, invokes...

RE: creates triggers for insert, update, and delete.

Thanks. Had not thought of triggers to track changes. but...

Re: If you are also concerned about SELECT, you have a...