Access VBA (²»¶Ï¸üÐÂÖÐ...)
1¡¢ÎÊÌâÃèÊö£ºÓÃVBA°ÑÊý¾Ý´ÓExcelµ¼Èëµ½Access£¨ÏµÍ³°æ±¾ºÅ£ºMicrosoft Windows XP Professional °æ±¾ 2002 Service Pack 3£»Office Access°æ±¾ºÅ£º2002/XP£©¡£
´úÂëÃèÊö£ºInsert Into [±íÃû]([×Ö¶Î1],[×Ö¶Î2]) " & _
"Select [ÁбêÌâ1],[ÁбêÌâ2]" & _
"from [Excel 9.0;Database=" & Îļþ·¾¶ºÍÎļþÃû³Æ & "].[ExcelÒ³Ãû$]"
²¹³ä˵Ã÷£º¿É°Ñ“[ÁбêÌâ1]”¸ÄΪһ¸ö±äÁ¿ È磺’“ & temp & ”‘
Èç¹û“[ÁбêÌâ1]”ÊÇÓ¢ÎÄ(Óпոñ)¿ÉÓÓ[]” Èç [is ok]
Èç¹û“ExcelÒ³Ãû”ÊÇÓ¢ÎÄ(Óпոñ)¿ÉÓÓ[]” Èç [Excal name]
ExcelÁбêÌâ²»ÄÜÓГ.”£¬²»ÄÜÓлسµ
´íÎóÌáʾ£ºÔËÐÐʱ´íÎó ‘3171’
ÕÒ²»µ½¿É°²×°µÄISAM
½â¾ö·½·¨£º"from [Excel 9.0;Database=" & Îļþ·¾¶ºÍÎļþÃû³Æ & "].[ExcelÒ³Ãû$]"Õâ¶Î´úÂ룬Excel°æ±¾ºÅ£¨¶ÔÓ¦Office 2002/XP£©Ö»ÄÜÊÇ8.
Ïà¹ØÎĵµ£º
Èí¼þÃû³Æ: EA2A(Excel/Access to Access)
Èí¼þ°æ±¾: beta2
ÊÚȨÐÎʽ: Ãâ·ÑÈí¼þ
ÔËÐÐÆ½Ì¨: Win9x/Me/NT/2000/XP/2003
Êý¾Ý¿âÉý¼¶ºóÔÓбíÖÐ×ֶλáÔö¼Ó£¬´ËʱÎÒÃǾÍÐèÒªµ¼Èë£¨Ç¨ÒÆ£©Êý¾Ý£¬´Ë³ÌÐòΪʵÏִ˹¦Äܶø±àд¡£
ͨ³£Èí¼þÉý¼¶ºó£¬Êý¾Ý¿âÒ²»áÓÐËù¸Ä±ä£¬´Ëʱ¾ÍÐèÒª¶Ô¿Í»§Ê¹ÓõÄÊý¾Ý¿â½øÐÐÉý¼¶¡£Éý¼¶¿Í»§Êý¾Ý¿âµÄ·½Ê½Ó ......
import java.sql.*;
/*
* JAVAÁ¬½ÓACCESS£¬SQL Server,MySQL,OracleÊý¾Ý¿â
*
* */
public class JDBC {
public static void main(String[] args)throws Exception {
Connection conn=null;
//====Á¬½ÓACCESSÊý¾Ý¿â ......
How to access HTTP server using Telnet
1¡¢Telnet www.baidu.com 80
Type : Ctrl + ]
//-------------------------------------------------------------------------------
Type : Enter
//-------------------------------------------------------------------------------
Input : GET / HTTP/1 ......
Ëùν“´æÈ¡¼ü”¾ÍÏñ windows Ó¦ÓóÌÐòÖÐµÄ Alt ¿ì½Ý¼ü£¬Í¬Ê±°´ Alt ¼üºÍij¸ö×Öĸ¼ü£¬¿ÉÒÔ¿ìËÙÇл»µ½Îı¾¿ò¡¢°´Å¥µÈÒ³Ãæ¶ÔÏóÉÏ¡£
(1)¡¢Îı¾¿òµÄ Access Key£º
<FORM>
<LABEL FOR="Namebox" ACCESSKEY="N"><U>N</U>ame:</LABEL>
<INPUT TYPE="TEXT" ID="Namebox" SIZE=30> ......
Private Sub cmdListProperties_Click()
ListControlProps Me
End Sub
Public Sub ListControlProps(ByRef frm As Form)
Dim ctl As Control
Dim prp As Property
On Error GoTo props_err
For Each ctl In ......