Dim p As String
Dim res As Integer
On Error Resume Next
p = ThisWorkbook.Path
If Right(p, 1) <> "\" Then p = p & "\"
With CreateObject("WScript.Shell")
.CurrentDirectory = p // カレントディレクトリを変える
End With
res = Shell("test.exe", vbNormalFocus)
If res <> 0 Then Application.WindowState = xlMinimized
Dim xls As Object
Dim wb As Object
Set xls = CreateObject("Excel.Application")
xls.DisplayAlerts = False
Set wb = xls.Workbooks.Open(FileName:=[Excelパス], ReadOnly:=True)
・・・(読込処理)・・・
wb.Close SaveChanges:=False
Set wb = Nothing
xls.DisplayAlerts = True
xls.Quit
Set xls = Nothing
UPDATE table1 SET
col1 = a.col1
, col2 = a.col2
FROM (SELECT .... FROM .... INNER JOIN ....) a
WHERE table1.id = a.id
とすると、
WITH句を使ったSQL文は
WITH a AS (
SELECT .... FROM .... INNER JOIN ....
)
UPDATE table1 SET
col1 = (SELECT col1 FROM a WHERE table1.id = a.id)
, col2 = (SELECT col2 FROM a WHERE table1.id = a.id)