Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extracting unique records | Excel Discussion (Misc queries) | |||
Extracting the Duplicate Records | Excel Discussion (Misc queries) | |||
Extracting Hyperlinks from 4000 graphic records | Excel Discussion (Misc queries) | |||
Extracting Records From Excel Database | Excel Discussion (Misc queries) | |||
Extracting unique records by formula | Excel Discussion (Misc queries) |