关于ASP?如何通过ASP把从IE上传的WORD/EXCEL/TXT文档中的数据存入数据库?(100分)

  • 主题发起人 lichen.com
  • 开始时间
L

lichen.com

Unregistered / Unconfirmed
GUEST, unregistred user!
关于ASP?如何通过ASP把从IE上传的WORD/EXCEL/TXT文档中的数据存入数据库(ACCESS/SQL SERVER)?
嫌分少,本人定会后补!!!!有劳各位大侠!!
 
存一个完整的文件,最好的办法是购买商业组件(aspupload等,很多)。
也有无组件上传的办法,原理是直接用ASP处理流数据,但是不太稳定,有时会出错。
看看ASP社区,有完美的解决方案。
 
去看看李维的书吧
上面有组件要不就去下一个
 
to LuJuhe:
>>存一个完整的文件,最好的办法是购买商业组件(aspupload等,很多)。
==那里能下载到关于这样的组件,我怕空间不支持组件,又要注册.
>>也有无组件上传的办法,原理是直接用ASP处理流数据,但是不太稳定,有时会出错。
==不要用组件,用ASP具体如何实现, 不稳定我不怕,只要是掌握这种方法.能不能把代码发给我,小弟必重谢!!
xsnet_cn@163.com如果能贴出来是最好的, 这样大家都能学到.
to lon911:
那里有下载?????
 
<SCRIPT RUNAT=SERVER LANGUAGE=VBSCRIPT>
'''''''''''''''''''''''''''''''''''''''''''''''''
'
'请保留此信息: 稻香老农制作 http://www.5xSoft.com/
'
'''''''''''''''''''''''''''''''''''''''''''''''''
dim upfile_5xSoft_Stream
Class upload_5xSoft
dim Form,File,Version
Private Sub Class_Initialize
dim iStart,iFileNameStart,iFileNameEnd,iEnd,vbEnter,iFormStart,iFormEnd,theFile
dim strDiv,mFormName,mFormValue,mFileName,mFileSize,mFilePath,iDivLen,mStr
Version="上传"
if Request.TotalBytes<1 then
Exit Sub
set Form=CreateObject("Scripting.Dictionary")
set File=CreateObject("Scripting.Dictionary")
set upfile_5xSoft_Stream=CreateObject("Adodb.Stream")
upfile_5xSoft_Stream.mode=3
upfile_5xSoft_Stream.type=1
upfile_5xSoft_Stream.open
upfile_5xSoft_Stream.write Request.BinaryRead(Request.TotalBytes)
vbEnter=Chr(13)&amp;Chr(10)
iDivLen=inString(1,vbEnter)+1
strDiv=subString(1,iDivLen)
iFormStart=iDivLen
iFormEnd=inString(iformStart,strDiv)-1
while iFormStart < iFormEnd
iStart=inString(iFormStart,"name=""")
iEnd=inString(iStart+6,"""")
mFormName=subString(iStart+6,iEnd-iStart-6)
iFileNameStart=inString(iEnd+1,"filename=""")
if iFileNameStart>0 and iFileNameStart<iFormEnd then
iFileNameEnd=inString(iFileNameStart+10,"""")
mFileName=subString(iFileNameStart+10,iFileNameEnd-iFileNameStart-10)
iStart=inString(iFileNameEnd+1,vbEnter&amp;vbEnter)
iEnd=inString(iStart+4,vbEnter&amp;strDiv)
if iEnd>iStart then
mFileSize=iEnd-iStart-4
else
mFileSize=0
end if
set theFile=new FileInfo
theFile.FileName=getFileName(mFileName)
theFile.FilePath=getFilePath(mFileName)
theFile.FileSize=mFileSize
theFile.FileStart=iStart+4
theFile.FormName=FormName
file.add mFormName,theFile
else
iStart=inString(iEnd+1,vbEnter&amp;vbEnter)
iEnd=inString(iStart+4,vbEnter&amp;strDiv)
if iEnd>iStart then
mFormValue=subString(iStart+4,iEnd-iStart-4)
else
mFormValue=""
end if
form.Add mFormName,mFormValue
end if
iFormStart=iformEnd+iDivLen
iFormEnd=inString(iformStart,strDiv)-1
wend
End Sub
Private Function subString(theStart,theLen)
dim i,c,stemp
upfile_5xSoft_Stream.Position=theStart-1
stemp=""
for i=1 to theLen
if upfile_5xSoft_Stream.EOS then
Exit for
c=ascB(upfile_5xSoft_Stream.Read(1))
If c > 127 then
if upfile_5xSoft_Stream.EOS then
Exit for
stemp=stemp&amp;Chr(AscW(ChrB(AscB(upfile_5xSoft_Stream.Read(1)))&amp;ChrB(c)))
i=i+1
else
stemp=stemp&amp;Chr(c)
End If
Next
subString=stemp
End function
Private Function inString(theStart,varStr)
dim i,j,bt,theLen,str
InString=0
Str=toByte(varStr)
theLen=LenB(Str)
for i=theStart to upfile_5xSoft_Stream.Size-theLen
if i>upfile_5xSoft_Stream.size then
exit Function
upfile_5xSoft_Stream.Position=i-1
if AscB(upfile_5xSoft_Stream.Read(1))=AscB(midB(Str,1)) then
InString=i
for j=2 to theLen
if upfile_5xSoft_Stream.EOS then
inString=0
Exit for
end if
if AscB(upfile_5xSoft_Stream.Read(1))<>AscB(MidB(Str,j,1)) then
InString=0
Exit For
end if
next
if InString<>0 then
Exit Function
end if
next
End Function
Private Sub Class_Terminate
form.RemoveAll
file.RemoveAll
set form=nothing
set file=nothing
upfile_5xSoft_Stream.close
set upfile_5xSoft_Stream=nothing
End Sub

Private function GetFilePath(FullPath)
If FullPath <> "" then
GetFilePath = left(FullPath,InStrRev(FullPath, "/"))
else
GetFilePath = ""
End If
End function
Private function GetFileName(FullPath)
If FullPath <> "" then
GetFileName = mid(FullPath,InStrRev(FullPath, "/")+1)
else
GetFileName = ""
End If
End function
Private function toByte(Str)
dim i,iCode,c,iLow,iHigh
toByte=""
For i=1 To Len(Str)
c=mid(Str,i,1)
iCode =Asc(c)
If iCode<0 then
iCode = iCode + 65535
If iCode>255 then
iLow = Left(Hex(Asc(c)),2)
iHigh =Right(Hex(Asc(c)),2)
toByte = toByte &amp;
chrB("&amp;H"&amp;iLow) &amp;
chrB("&amp;H"&amp;iHigh)
else
toByte = toByte &amp;
chrB(AscB(c))
End If
Next
End function
End Class

Class FileInfo
dim FormName,FileName,FilePath,FileSize,FileStart
Private Sub Class_Initialize
FileName = ""
FilePath = ""
FileSize = 0
FileStart= 0
FormName = ""
End Sub
Public function SaveAs(FullPath)
dim dr,ErrorChar,i
SaveAs=1
if trim(fullpath)="" or FileSize=0 or FileStart=0 or FileName="" then
exit function
if FileStart=0 or right(fullpath,1)="/" then
exit function
set dr=CreateObject("Adodb.Stream")
dr.Mode=3
dr.Type=1
dr.Open
upfile_5xSoft_Stream.position=FileStart-1
upfile_5xSoft_Stream.copyto dr,FileSize
dr.SaveToFile FullPath,2
dr.Close
set dr=nothing
SaveAs=0
end function
End Class
</SCRIPT>
 
用ASP.NET,直接就有上传的组件,根据上传的文件名写过程写入数据库。
不过我觉得文件格式的问题很大,怎么控制它里面的内容完全按照你的格式挺讨厌。
我原来遇到这样的问题,同一个字段在EXCEL中出现两次,第二次 出现的被作为纪录读入了。
 

Similar threads

回复
0
查看
827
不得闲
S
回复
0
查看
3K
SUNSTONE的Delphi笔记
S
S
回复
0
查看
2K
SUNSTONE的Delphi笔记
S
S
回复
0
查看
962
SUNSTONE的Delphi笔记
S
S
回复
0
查看
784
SUNSTONE的Delphi笔记
S
顶部