ÇóÒ»¸öдÈëACCESSÊý¾Ý¿âµÄ´úÂë
ÒªÒ»¸ö×î¼òµ¥µÄ£¬Ò»¸ö¶¯Ì¬Ò³£¬Ò»¸öÊý¾Ý¿âÎļþ
ÒòΪÎÒ×Ô¼º×öÁË´æ²»½øÈ¥£¬ÎÒÕÒ²»µ½ÔÒò
ÒªASPµÄ¡£´æ½øÊý¾Ý¾ÍÐÐÁË¡£²»Òª¹¦ÄÜ¡£
°Ù¶ÈÉϵĴúÂë¶àµÄÊÇ£¬¿½±´¾ÍÊÇÁË¡£
»òÐíÄãµÄ´úÂëÒѾÊǶԵģ¬ÖÁÓÚΪʲô´æ²»½øÈ¥¿ÉÄÜÊÇÄãµÄaccessÎļþ¼Ð·ÃÎÊȨÏÞµÄÎÊÌâ¡£
×î¼òµ¥µÄ½â¾ö°ì·¨£º°ÑaccessËùÔÚĿ¼ÖУ¬²é¿´ÊôÐÔ£¬Ìí¼ÓeveryoneÓû§µÄ¿ÉÐÞ¸ÄȨÏÞ¡£
100Ôª qq:595563946
<%
On Error Resume Next
Dim conn,connStr
Set conn=Server.CreateObject("ADODB.connection")
'connStr="Driver={Microsoft Access Driver (*.mdb)};dbq="&Server.MapPath("person.mdb")
connStr="Driver={SQL Server};Server=(local);Uid=sa;Pwd=sa;Database=UserTest"
conn.open connStr
If Err Then
Err.clear
Call CloseConn()
Response.End
End If
Sub CloseConn()
conn.close
Set conn=nothing
End Sub
%> Á¬½ÓÊý¾Ý¿âµÄÎļþ
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn.asp"-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charse
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
jsp¿ª·¢µÄʱºòÄܹ»µ¼³öwordºÍexcel£¬µ«ÊÇÊÇ·ñÄܹ»Ö±½Óµ¼³öΪacess¸ñʽ¡¢dbf¸ñʽµÄÎļþ£¿
¸ßÊÖÖ¸µãÏ£¬×îºÃÄܹ»¸ø¸öÀý×Ó£¬Ð»Ð»£¡£¡£¡
javadbfÕâ¸öjarÒ»ÇÐÎÊÌâ½â¾öÁË¡£
ÏÂÔØµØÖ·Îª£ºhttp://sarovar.org/projects/ ......
×î½üѧϰasp£¬µ±Á·Ï°µ½Á¬½ÓÊý¾Ý¿âµÄʱºò£¬ÆµÆµ³ö´í£¬¿É¾ÍÊDz»ÖªµÀ´íÔÚÔõôµØ·½£¬Çë¸ßÊÖ°ïæ¿´¿´£¡£¡Ð»Ð»£¡
°üº¬Îļþxx.asp¡¢xxsave.asp¡¢conn.aspÒÔ¼°student1.mdbºÍ±íxxgl¡¡
xx.aspΪ£º
<html>
<hea ......
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......