ÈçºÎ½«excelµ¼Èëµ½Ö¸¶¨µÄACCESS±íÖÐÄØ£¿ ²»ÓôúÂë
ÈçºÎ½«excelµ¼Èëµ½Ö¸¶¨µÄACCESS±íÖÐÄØ£¿ ²»ÓôúÂëʵÏÖ
ÓÐûÓа취£¿
...
sqlÓï¾ä£¿
²»ÓôúÂë¡£¡£²»Ð´³ÌÐò¡£¡£¡£¸´ÖÆÕ³Ìù°É
DTSµ¼Èëµ¼³öµÄʱºòÊý¾ÝÔ´ÎÒÑ¡ÔñµÄÊÇexcel£¬È»ºó»¹ÈÃÎÒÊäÈëÓû§ÃûºÍÃÜÂ룬 ËûÃÇÊǶàÉÙ°¡£¿
²»ÓôúÂëʵÏÖ
??
ÄǾÍÔÚaccessÀïÊÖ¶¯µ¼ÈëexcelÀ²£¡
Ctrl+C, Ctrl+V
²»ÓôúÂëExcelµ¼ÈëAccess
EA2A(Excel/Access to Access)
http://blog.csdn.net/cadenza7/archive/2009/09/04/4518456.aspx
ÏÂÔØ1 http://download.csdn.net/source/1630023 (CSDNÓû§ÏÂÔØ)
ÏÂÔØ2 http://cadenza7.qupan.com/4492412.html (ÆäËüÓû§ÏÂÔØ)
EA2A(Excel/Access to Access)
Èí¼þ½éÉÜhttp://blog.csdn.net/cadenza7/archive/2009/09/04/4518456.aspx
ÏÂÔØ1 http://download.csdn.net/source/1630023 (CSDNÓû§ÏÂÔØ)
ÏÂÔØ2 http://cadenza7.qupan.com/4492412.html (ÆäËüÓû§ÏÂÔØ)
Ïà¹ØÎÊ´ð£º
IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)
'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ
µ±Êý¾Ý¿â×Ö¶ÎΪ¡ ......
ÎÒµÄÒ»¸öaccessÊý¾Ý¿âÖеÄphoto×Ö¶ÎÖеÄÄÚÈÝÊÇÕâÑùµÄ£º
|/UpFiles/Picture/admin/200910162300187612.jpg|/UpFiles/Picture/admin/200910162300187612.jpg||||/UpFiles/Picture/admin/200910162300187612.jpg ......