刚刚梦贴了IP表，这个是一个把它存入SQL里的程序

写得比较粗糙，还有一点错误，不过能达到效果，凑合着用了，是4266条，不知道对也不对
create.asp
-----------------------------------------------------------------------
<%
'Option Explicit
Server.Scripttimeout = 1000
On Error Resume Next
' Define your sql info here
strSQLDSN = "xxxx"
strSQLUsername = "sa"
strSQLPassword = ""
' This is where we connect to our sql server
Set adoConn = Server.CreateObject("ADODB.Connection")
ConnectionString = "dsn=" & strSQLDSN & ";uid=" & strSQLUsername & ";pwd=" & strSQLPassword & ""
adoConn.Open ConnectionString
'Set adoRS = Server.CreateObject("ADODB.Recordset")
' get sql from ip.txt
Set fso = Server.Createobject("Scripting.FilesystemObject")
    If fso.Fileexists(Server.Mappath("ip.txt")) then
    Set a = fso.OpenTextFile(Server.Mappath("ip.txt"), 1, False)
        Do While a.AtEndOfStream <> True
           sql = a.readline
           adoConn.Execute (sql)
        Loop
    a.close
    set a = nothing
    Else
    Response.Write "文件没找到"
    Response.End
    End if
Set fso = Nothing
'Error Handle
If err.number <> 0 then
        
        ' this code come from http://bigeagle.wotoo.com
        strMsg = strMsg + "********************************************" + vbcrlf

补充：asp教程,高级应用