Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

EA2A(Excel/Access to Access)

Èí¼þÃû³Æ: EA2A(Excel/Access to Access)
Èí¼þ°æ±¾: beta2
ÊÚȨÐÎʽ: Ãâ·ÑÈí¼þ
ÔËÐÐƽ̨: Win9x/Me/NT/2000/XP/2003
Êý¾Ý¿âÉý¼¶ºóÔ­ÓбíÖÐ×ֶλáÔö¼Ó£¬´ËʱÎÒÃǾÍÐèÒªµ¼È루ǨÒÆ£©Êý¾Ý£¬´Ë³ÌÐòΪʵÏִ˹¦Äܶø±àд¡£
ͨ³£Èí¼þÉý¼¶ºó£¬Êý¾Ý¿âÒ²»áÓÐËù¸Ä±ä£¬´Ëʱ¾ÍÐèÒª¶Ô¿Í»§Ê¹ÓõÄÊý¾Ý¿â½øÐÐÉý¼¶¡£Éý¼¶¿Í»§Êý¾Ý¿âµÄ·½Ê½ÓУº
1.Ð޸ĵ±Ç°Êý¾Ý±íµÄ×ֶΣ¬±ÈÈçÌí¼ÓÁУ¬ÓÖ·ÖΪ¿ÉÊÓ»¯´´½¨ºÍʹÓÃSQL½Å±¾¶þÖÖ·½Ê½¡£
2.´´½¨ÁÙʱ±í→ɾ³ýԭʼ±í→´´½¨Ð±í→×îºóÔÙ½«ÁÙʱ±íÊý¾Ý²åÈëµ½ÐÂ±í¡£
ÕâЩ²Ù×÷ÊDz»ÊDZȽϷ±Ëö£¬Ê¹ÓÃEA2AÔò¿ÉÒÔ½ÚÊ¡ºÜ¶à²»±ØÀ˷ѵÄʱ¼ä£¬²»±Øµ±ÐÄÿ´Î³ÌÐòÉý¼¶ºóÊý¾Ý¿â²úÉúµÄÏàÓ¦±ä»¯¡£
EA2A¿ÉÒÔ×÷ΪÊý¾ÝÉϱ¨Ê±µÄµ¼È빤¾ß£¬±ÈÈçϼ¶»ú¹Ø¶ÔÉϼ¶»ú¹ØÉϱ¨Êý¾Ý£¨¿ÉÉϱ¨Excel/Access¸ñʽ£©¡£
EA2AÖ§³ÖAccessÊý¾Ý¿â±íÓë±í¡¢ÊÓͼÓëÊÓͼ֮¼äÊý¾ÝµÄ»¥µ¼¡£
EA2A¿É×öΪ¼òµ¥µÄSQL²éѯ·ÖÎöÆ÷ʹÓã¬Èç¹û´ò¿ª·½Ê½ÎªExcel£¬½öÖ§³Ö²éѯÓï¾ä£¬±ÈÈçselect * from [user$] where id=2£¬Èç¹û´ò¿ª·½Ê½ÎªAccessÔòÖ§³Ö¼¸ºõËùÓеÄSQLÓï¾ä£¬±ÈÈçinsert/update/delete/Create/DropµÈµÈ¡£
SQL ½Å±¾Ö´ÐÐ
Êý¾Ýµ¼Èë
Ôö¼Ó»ò¸üÐÂGUID×Ö¶Î
Èç¹ûÄúÓÐʲôºÃµÄÒâ¼þºÍ½¨ÒéÇë¸øÎÒ·¢E-mail,ллÄúµÄʹÓÃ.  :)
Powered by kyo
E-mail: kyo_2360#sina.com  ½«#»»³É@
ÏÂÔØ1 http://download.csdn.net/source/1630023 (CSDNÓû§ÏÂÔØ)
ÏÂÔØ2 http://cadenza7.qupan.com/4492412.html (ÆäËüÓû§ÏÂÔØ)
home page http://blog.csdn.net/cadenza7


Ïà¹ØÎĵµ£º

AccessÊý¾Ý¿âÔÚC#.netϵĴ洢·¾¶ÎÊÌâ

¼´Ê¹ÎÒ½«Êý¾Ý¿â·ÅÔÚÏîÄ¿ÄÚ½¨µÄÎļþ¼ÐdbÏ£¬¿ÉÊǽøÐд洢²Ù×÷µÄʱºò£¬Êý¾Ý±íûÓÐÈκα仯¡£ºóÀ´·¢ÏÖ´¢´æ¸Ä±ä·¢ÉúÔÚbin\\debug\\dbĿ¼ÏµÄÊý¾Ý¿âÖУ¬Õâ¸öÊý¾Ý¿âÊÇÔÚ³ÌÐòÔËÐÐʱ×Ô¶¯¸´ÖƹýÈ¥µÄ£¬¿ÉÊÇΪʲô´æ´¢±ä»¯Ã»Óз´Ó¦µ½ÍâÃæÏîÄ¿ÄÚµÄÊý¾Ý¿âdbÏÂÄØ£¿ÎÒÏëÁ¬½Ó×Ö·û´®ÖÐdatasourceÖеÄdatadirectory´æÔÚһЩÐþ»ú£¬ÓÚÊÇÎÒÕÒµ½Ò ......

ASP.NETµÄACCESSÊý¾Ý¿â²Ù×÷Àà

//private string datapatch = ConfigurationSettings.AppSettings["acessconn"];//Êý¾Ý¿âµØÖ· 
private string datapatch = "db/global.asa";//Êý¾Ý¿âµØÖ· 
/// 
/// È¡µÃdataset 
// 
/// ²éѯÓï¾ä 
/// 
public DataSet GetDataSet(string Commandtext) 
{&nbs ......

asp.netÁ´½ÓAccessÊý¾Ý¿â×Ö·û´®ÕýÈ··½·¨

ÔÚweb  configÖР ×÷ÈçÏÂÅäÖãº
<connectionStrings>
    <add name="ydycon" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=|DataDirectory|ydy.mdb" providerName="System.Data.OleDb"/>
 
  </connectionStrings>
ÔÚ.netÎļþÖÐÓ¦ÓÃÁ´½Ó ......

accessº¯Êý²Î¿¼

ÈÕÆÚ/ʱ¼ä
CDate  ½«×Ö·û´®×ª»¯³ÉΪÈÕÆÚ select CDate("2005/4/5")
Date  ·µ»Øµ±Ç°ÈÕÆÚ
DateAdd  ½«Ö¸¶¨ÈÕÆÚ¼ÓÉÏij¸öÈÕÆÚselect dateAdd("d",30,Date())½«µ±Ç°ÈÕÆÚ¼ÓÉÏ30Ìì,ÆäÖÐd¿ÉÒÔ»»Îªyyyy»òHµÈ
DateDiff ÅжÏÁ½¸öÈÕÆÚÖ®¼äµÄ¼ä¸ô select DateDiff("d","2006-5-1& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ