Is there a way to cause Excel to multiple SQL's in one read? To be specific,
when you are extracting data via ODBC using SQL, if you encounter a record
lock, an error message is received saying that the next record could not be
read. When just running the SQL statements, you can seperate them with ";"
and cause all statements to be read. What I would like to do is the cause
Excel to allow me to run a SQL statement such as 'SET ISOLATION DIRTY READ'
before it executes the data extraction SQL. i cannot seem to get Excel to do
this. Does anyone have any ideas on how this might be done?