Sub Limonet()
Dim StrSQL$, Cn As Object, IntoF$
IntoF$ = "Into Sheet1 From [Excel 12.0;Database=" & ThisWorkbook.FullName & "].[产品表$C15:Y] Where"
Set Cn = CreateObject("ADODB.connection")
Cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties=Excel 12.0 XML;Data Source=" & ThisWorkbook.Path & "\可食用产品-" & Year(Date) & Format(Month(Date) + 1, "00") & ".xlsx"
StrSQL = "select 产品号,产品名称,产品编号1,产品编号2,产品编号3,产品编号4,产品编号5,产品编号6,是否可使用,使用范围1,使用范围2,使用范围3 " & IntoF$ & " 是否可使用='是'"
Cn.Execute (StrSQL): Cn.Close
Cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties=Excel 12.0 XML;Data Source=" & ThisWorkbook.Path & "\小瓶产品-" & Year(Date) & Format(Month(Date) + 1, "00") & ".xlsx"
StrSQL = "Select 产品号,产品名称,产品编号1,产品编号2,产品编号3,产品编号4,产品编号5,产品编号6,生产日期,到期日 " & IntoF$ & " [三] like '小瓶'+'%' and [七] Like '%'&'[A-C]'"
Cn.Execute (StrSQL): Cn.Close
Cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties=Excel 12.0 XML;Data Source=" & ThisWorkbook.Path & "\小瓶浓度产品-" & Year(Date) & Format(Month(Date) + 1, "00") & ".xlsx"
StrSQL = "Select 产品号,产品名称,产品编号1,产品编号2,产品编号3,产品编号4,产品编号5,产品编号6,生产日期,到期日 " & IntoF$ & " [三] like '小瓶'+'%' or [四] Like '浓度'&'%'"
Cn.Execute (StrSQL): Cn.Close
End Sub |