您好,我希望每天上午9点运行以下代码基本上,代码将读取一个txt文件,并从每一行读取。它将处理并插入到Mysql表中。我该如何做到这一点?我找到了以下Make server automatic run asp-script every day,但它不起作用。请帮帮忙。
<%
strFileName = "database/testdata.txt"
Set fso = Server.CreateObject("Scripting.FileSystemObject")
set fs = fso.OpenTextFile(Server.MapPath(strFileName), 1, true)
if not fs.AtEndOfStream then
Do while not fs.AtEndOfStream
strRow = fs.ReadLine
sDate = Mid(Trim(strRow), 1, 8)
Set rstTMClk1 = server.CreateObject("ADODB.RecordSet") '=== Transfer from file to TMCLK1
sSQL = "select * from TMCLK1 '"
rstTMClk1.Open sSQL, conn, 3, 3
if rstTMClk1.eof then '=== To avoid duplicates
sSQL = "insert into TMCLK1 (DT_WORK) "
sSQL = sSQL & "values ("
sSQL = sSQL & "'" & fdate2(sDate) & "'"
sSQL = sSQL & ") "
conn.execute sSQL
end if
pCloseTables(rstTMClk1)
Loop
end if
pCloseTables(fs)
%>https://stackoverflow.com/questions/47431976
复制相似问题