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
Ïà¹ØÎĵµ£º
¼´Ê¹ÎÒ½«Êý¾Ý¿â·ÅÔÚÏîÄ¿ÄÚ½¨µÄÎļþ¼ÐdbÏ£¬¿ÉÊǽøÐд洢²Ù×÷µÄʱºò£¬Êý¾Ý±íûÓÐÈκα仯¡£ºóÀ´·¢ÏÖ´¢´æ¸Ä±ä·¢ÉúÔÚbin\\debug\\dbĿ¼ÏµÄÊý¾Ý¿âÖУ¬Õâ¸öÊý¾Ý¿âÊÇÔÚ³ÌÐòÔËÐÐʱ×Ô¶¯¸´ÖƹýÈ¥µÄ£¬¿ÉÊÇΪʲô´æ´¢±ä»¯Ã»Óз´Ó¦µ½ÍâÃæÏîÄ¿ÄÚµÄÊý¾Ý¿âdbÏÂÄØ£¿ÎÒÏëÁ¬½Ó×Ö·û´®ÖÐdatasourceÖеÄdatadirectory´æÔÚһЩÐþ»ú£¬ÓÚÊÇÎÒÕÒµ½Ò ......
//private string datapatch = ConfigurationSettings.AppSettings["acessconn"];//Êý¾Ý¿âµØÖ·
private string datapatch = "db/global.asa";//Êý¾Ý¿âµØÖ·
///
/// È¡µÃdataset
//
/// ²éѯÓï¾ä
///
public DataSet GetDataSet(string Commandtext)
{&nbs ......
ÔÚweb configÖÐ ×÷ÈçÏÂÅäÖãº
<connectionStrings>
<add name="ydycon" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=|DataDirectory|ydy.mdb" providerName="System.Data.OleDb"/>
</connectionStrings>
ÔÚ.netÎļþÖÐÓ¦ÓÃÁ´½Ó ......
ÈÕÆÚ/ʱ¼ä
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& ......