![]() |
Extracting records via SQL in Excel
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? |
All times are GMT +1. The time now is 12:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com