Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.
but I get the error attached. why?
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=CBRHKMA;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"";" ... s = "delete from [ODBC;Description=TEST;DRIVER=SQL Server;" _ & "SERVER=PC336_W7_HKMA;Trusted_Connection=Yes;" _ & "DATABASE=CBRHKMA].T41 " _ & "where [Reporting Date]=convert(datetime,'" & Mid(strLine, pos0, 8) & "',112)" ...
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.