K
Ken Ent
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?
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?