When you connect Excel to a database using Microsoft Query, what do you need
to do to the SQL code to ensure that the query does not lock the tables that
it is pulling information from?

In other words, how can you continue to allow additions/deletions to the
tables, while the query is running?

There are versions of SQL where you can put WITH (NOLOCK) after the FROM,
but this gives me an error in Microsoft Query.

Thank you for any help you can give me.