請問各位因我欄位有40個~目前是以以下方式去做串接
但做到第1X個之後就警告說串接過多了~
請問可以怎麼做改進呢?
Excel to Azure sql
- Sql = "IF NOT EXISTS (SELECT 編號 from BOM WHERE 編號 ='" & sLastName & "') " & _
- " INSERT into BOM (單號, 編號) " & _
- " VALUES ('" & sFirstName & "', '" & sLastName & "')" & _
- " else " & _
- " update BOM set" & _
- " 欄1= '" & s周期 & "'," & _
- " 欄2 = '" & s特殊 & "'," & _
- " 欄3 = '" & s日期 & "'," & _
- " 欄4 = '" & s編號 & "'," & _
- " 欄5 = '" & s餐別 & "'," & _
- " 欄6 = '" & s類別 & "'," & _
- " 欄7 = '" & s品名 & "'," & _
- " 欄8 = '" & s數量 & "'," & _
- " 欄9 = '" & s備註 & "'," & _
- " 欄10 = '" & s異常 & "'," & _
- " 欄11 = '" & s代號 & "'" & _
- " where 編號 ='" & sLastName & "'"
|
發表於 2018-8-29 11:33
| 
