ACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ÔÚæÂð?
ͨ¹ýodbcÁ¬½ÓµÄ
Ïà¹ØÎÊ´ð£º
´úÂ룺
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con= DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost: ......
ÔÚTEXT1.TEXT ÖжÁÈ¡EXCELµÄ·¾¶
Ñ¡Ôñcombo1.textÖеÄÊý¾Ý±íÃû³Æ
µã»÷µ¼Èëºó Èç¹û×ֶκÍÊý¾Ý¿âµÄÒ»Ñù ¾ÍÖ´Ðе¼Èë ·ñÔòÌáʾ³ö´íÐÅÏ¢
¸÷λ´ó¸ç°ï°ïСµÜ ÒªÔõôдÕâ¸öÖ´ÐгÌÐò ÏÖÔÚ ......
н¨µ¥Îĵµ³ÌÐòÑ¡ÔñODBCÖеÄÊý¾ÝԴʱ×ÜÊǵ¯³öÒ»¸öµÇ¼´°¿ÚÒªÊÚȨ¡£¡£¡£»¹ÒªÃÜÂë¡£¡£¡£
ÆäËûµÄµ÷ÓÃODBCÖеÄÊý¾ÝÔ´ÊǾͲ»ÐèÒªÕâ¸ö£¬¿ÉÒÔÔËÐС£
ŪÁ˺ó¤Ê±¼äÁË¡£¡£¡£
ûÓö¼û¹ý£¬¿ ......
¸÷λ´óÏÀ£º
ÔÚ´°ÌåÀïÓÐÒ»Áбí¿ò£¬ÃûÔ»¡°ÉÌÆ·±àºÅ¡±£¬ÐÐÀ´Ô´ÀïµÄÄÚÈÝÓУºÉÌÆ·±àºÅºÍÉÌÆ·Ãû£¨À´×ÔÉÌÆ·±í£©¡£
µ«ÊÇÎÊÌâ³öÏÖÁË£ºÔÀ´ÉÌÆ·±íÀïµÄÉÌÆ·±àºÅÊÇ4λ£ ......
access vba ÖÐÔõôȡµÃÊý×鳤¶È£¿
Êý×éÐУ¿
UBound(Êý×éÃû)
ubound()-lbound()
UBound º¯Êý
·µ»ØÒ»¸ö Long ÐÍÊý¾Ý£¬ÆäֵΪָ¶¨µÄÊý×éά¿ÉÓõÄ×î´óϱꡣ
Óï·¨ ......