Accessµ¼³öEXCEL£¬¹ØÓÚ×Ö¶ÎÃûÏÔʾÔÚÁÐÏò
Çë´ó¼ÒÖ§³Ö£¬Ð»Ð»-³õ¼¶AccessÓû§¡£
Ŀǰµ¼³öµÄÊý¾ÝÈçÏ£º
×Ö¶Î1 ×Ö¶Î2 ×Ö¶Î3
A B C
ÎÒ¿ÊÍûʵÏÖµ¼³öÀ´µÄ¸ñʽΪ
×Ö¶Î1 A
×Ö¶Î2 B
×Ö¶Î3 C
ÎļþÒÑÉÏ´«
http://access911.net/csdn/FileDescription.asp?mdb=2010-1-21&id=36
select '×Ö¶Î1',×Ö¶Î1 from tt
union
select '×Ö¶Î2',×Ö¶Î2 from tt
union
select '×Ö¶Î3',×Ö¶Î3 from tt
×ÔÐÐÐÞ¸Ä
лл£¬ÒѾʵÏÖÁË
ÁíÎÊ£ºÇëÎÊÈçºÎ¿ÉÒÔÉèÖõ¼³öµ½ExcelÀïµÄ×ÖÌ壬ÒÔ¼°ÔÚµ¥Ôª¸ñÊÇ·ñ¾ÓÖлòÕ߯«×óʲôµÄ£¬ÒÔ¼°Èç¹ûÎÒÏë¸øµÚÒ»ÁеÄÑÕɫĬÈÏΪ»ÒÉ«£¬ÇëÎÊÔÚÖмä¸Ã¼ÓÈëÄÄЩ´úÂëÄØ£¿
ÎÒÒѾÃþË÷µ½ÈçºÎ½â¾öÁË£¬ÏȽáÌùºÇºÇ£¬Ð»Ð»Á˸÷λ
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......
Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit
ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......
ÎÊÌ⣱
ÎÒÓÃADOÁ¬½ÓÉèÁËÓû§ÃûÃÜÂëµÄÊý¾Ý¿â
µ«ÊÇÎÒ·¢ÏÖÎÒ²»ÊäÈë Óû§ÃûºÍÃÜÂë ¶¼¿ÉÒÔÁ¬½Ó³É¹¦ ¶øÇÒ»¹ÄܰÑÊý¾Ý¶Á³öÀ´
¼ôÁËÒ»¸öÃûΪtestÊý¾Ý¿â ½¨ÁËÒ»¸öÃûΪpeopleµÄ±í
¼ûÁËÒ»¸ö Óû§Ãû1234 ÃÜÂë1234 µÄ ......
Çë´ó¼Ò°ï棬ÎÒÏëÔÚAccess´°ÌåÀïÃæÏÔʾ±íºó£¬Ñ¡Ôñ±íÖеÄij¸ö×ֶΣ¬¾Í¿ÉÒÔ¸ù¾ÝÑ¡ÔñµÄÕâЩµ¥Ôª¸ñÇóºÍ¡¢Ç󯽾ù£¬¾ÍÈçExcelÓÒϽÇ״̬À¸ÄÇÑù£¬ºÜ·½±ãµÄͳ¼ÆÇóºÍÇ󯽾ù£¬Ð»Ð»£¡
Äã¿ÉÒÔÓÃÒ»¸ögridview »òÕ߯äËûʲô¿Ø¼þ ¶ ......