Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
An ODBC question
I have been using the following to query a database through ODBC:
With ActiveSheet.QueryTables.Add(Connection:="ODBC;DATA BASE=DB; UID=user;PWD=password;DSN=sDSN, Destination:=Range("A1"), Sql:=sSQL) .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .PreserveColumnInfo = True .RefreshOnFileOpen = False .BackgroundQuery = True .RefreshStyle = xlOverwriteCells .SavePassword = True .SaveData = True .AdjustColumnWidth = False .RefreshPeriod = 0 .PreserveColumnInfo = True .Refresh BackgroundQuery:=False End With If sSQL is a SELECT, there is no problem. If it is a DELETE, I have to set 'Refresh BackgroundQuery' to True. Otherwise I will get an Application Defined or Object Defined error. What was wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complicated ODBC data refresh question. | Excel Discussion (Misc queries) | |||
ODBC | Excel Discussion (Misc queries) | |||
Shared xls using ODBC/JET | Excel Discussion (Misc queries) | |||
ODBC | Excel Discussion (Misc queries) | |||
Oracle odbc | Excel Discussion (Misc queries) |