aspÉÏ´«excleÎļþ²¢µ¼Èëµ½accessÊý¾Ý¿â
<%
function FSOFileDel(filename)
Dim objFSO,objCountFile,FiletempData
On Error Resume Next
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
Set objCountFile =objFSO.DeleteFile(Server.MapPath(filename),true)
objCountFile.Close
Set objCountFile=Nothing
Set objFSO = Nothing
End Function
dim action,files
action=trim(request("action"))
files=trim(request("files"))
select case action
case "add"
call add(files)
case else
call default()
end select
%>
<%sub default()%>
<form action="?action=add" method="post" id="form1" name="form1">
<table border="0" cellspacing="0" cellpadding="0">
<tr class="title2">
<td colspan="2">ÅúÁ¿ÉÏ´«</td>
</tr>
<tr>
<td>1.ÉÏ´«ExcleÎļþ </td>
<td><input name="files" type="hidden" id="files" />
<iframe frameborder="0" scrolling="no" height="25" width="400" src="upload.asp?action=add"></iframe> </td>
</tr>
<tr>
<td>2.µã»÷"¿ªÊ¼ÉÏ´«" </td>
<td> <label>
<input type="submit" name="button" id="button" value="¿ªÊ¼ÉÏ´«" />
</label> </td>
</tr>
</table>
</form>
<%end sub%>
<%
sub add(files)
dim FileName
if files="" then ClientAlert"ÇëÏÈÉÏ´«ExcleÎļþ","?"
FileName="../upload/file/"&files 'È¡µÃÎļþ·¾¶
Dim connEX
set connEX=CreateObject("ADODB.connection")
connEX.Open "Driver={Microsoft Excel Driver (*.xls)};" & _
"DriverId=790;" & _
"Dbq=" & server.mappath(""&FileName&"") & ";" & _
"DefaultDir=G:\"
set rs=createobject("ADODB.recordset")
rs.Open "Select * from [Sheet1$]",connEX, 2, 2
if rs.eof then
response.write "Excel±íÖÐÎ޼ͼ"
else
' set connDB = Server.CreateObject("ADODB.Connection")
' DBPath = Server.MapPath("excel.mdb")
' 'RESPONSE.WRITE DBpath
' connDB.Open "driver=
Ïà¹ØÎĵµ£º
ASP.NET µÇ¼¿Ø¼þΪ ASP.NET Web Ó¦ÓóÌÐòÌṩÁËÒ»ÖÖ¿É¿¿µÄ¡¢ÎÞÐè±à³ÌµÄµÇ¼½â¾ö·½°¸¡£Ä¬ÈÏÇé¿öÏ£¬µÇ¼¿Ø¼þÓë ASP.NET ³ÉÔ±×ʸñºÍ Forms Éí·ÝÑéÖ¤¼¯³É£¬ÒÔ°ïÖúʵÏÖÍøÕ¾µÄÓû§Éí·ÝÑéÖ¤¹ý³ÌµÄ×Ô¶¯»¯¡£
ĬÈÏÇé¿öÏ£¬ASP.NET µÇ¼¿Ø¼þÒÔ´¿Îı¾ÐÎʽ¹¤×÷ÓÚ HTTP ÉÏ¡£Èç¹ûÄú¶Ô°²È«ÐÔÊ®·Ö ......
Äú¿ÉÒÔͨ¹ýÒÔÏ·½·¨×Ô¶¨Òå¶à¸ö ASP.NET µÇ¼¿Ø¼þµÄÄÚÈÝ£ºÖ¸¶¨¿Ø¼þÄ£°å²¢½«×Ô¼ºµÄ¿Ø¼þÌí¼Óµ½¿Ø¼þµÄÓû§½çÃæ (UI)£¬»òÕßÌæ»»»òÒÆ³ý¿Ø¼þµÄÓû§½çÃæ²»ÐèÒªµÄ¿ÉÑ¡¿Ø¼þ¡£»¹¿ÉÒÔʹÓõǼ¿Ø¼þµÄÑùʽÊôÐÔÒÔ¼°Ö÷ÌâºÍÍâ¹ÛÀ´¶¨ÖƿؼþµÄÍâ¹Û¡£
Ò»¡¢¿É×Ô¶¨ÒåµÄµÇ¼¿Ø¼þ
¶ÔÓÚ¿ÉÒÔʹÓÃÄ£°åÌæ»» ......
¿ÉÒÔʹÓà ASP.NET Login ¿Ø¼þ´´½¨µÇ¼ҳ¡£´Ë¿Ø¼þÌáÈ¡Óû§ÃûºÍÃÜÂ룬²¢Ê¹Óà ASP.NET ³ÉÔ±×ʸñºÍ Forms Éí·ÝÑéÖ¤À´ÑéÖ¤Óû§µÄƾ¾Ý²¢´´½¨Éí·ÝÑé֤Ʊ֤¡£
1¡¢´´½¨Ò»¸öʹÓà ASP.NET ³ÉÔ±×ʸñµÄ ASP.NET Web Ó¦ÓóÌÐò¡£ÓйØÏêϸÐÅÏ¢ºÍʾÀý£¬Çë²Î¼ûÅäÖà ASP.NET Ó¦ÓóÌÐòÒÔʹÓóÉÔ±×ʸñ ......
1.´íÎóÀàÐÍ£º
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] ²Ù×÷±ØÐëʹÓÃÒ»¸ö¿É¸üеIJéѯ¡£
Õâ¸ö´íÎóÒ»°ãÖ»ÓÐÔÚʹÓÃACCESSÊý¾Ý¿âʱ²Å»á³öÏÖ¡£ÒòΪACCESSÔÚ´ò¿ªÊ±»áÉú³ÉÒ»¸öÁÙʱÎļþ.ldb£¬ÕâʱÎļþ¼ÐÈç¹ûûÓÐдÈëȨÏÞʱ£¬Ôò»á·¢Éú´íÎó¡£
½â¾ö·½·¨ÈçÏ£º
1 ......
Ò». Ora-24801:ÔÚOCI_lobº¯ÊýÖзǷ¨µÄ²ÎÊýÖµ
°ÑÒ»Õź¬ÓГ±¸×¢”×ֶεıíͨ¹ýODBCµ¼³öµ½OracleµÄʱºòÒ»Ö±³öÏÖÈçÉÏͼËùʾµÄÌáʾÐÅÏ¢¡£³¢ÊÔÈ¥µôÏà¹Ø×Ö¶ÎÖпոñ×Ö·û£¬È¥µô×Ö¶ÎΪ¿ÕµÄ¼Ç¼£¬»¹Êǵ¼³öʧ°Ü¡£×îºóżȻ·¢ÏÖ£¬ÖØÐ½¨Ò»ÕÅÏàͬ½á¹¹µÄ¿Õ±í£¬È»ºó¸´ÖÆÔ±íµÄ¼Ç¼£¬ÔÙÕ³Ìùµ½Ð±íÖУ¬µ¼³öµ½Oracle¾ ......