ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Extracting records via SQL in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/232370-extracting-records-via-sql-excel.html)

Ken Ent

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