ʵÏÖÓÉÎı¾µ¼Èëµ½AccessÒѾ¶¨ÒåºÃµÄ±í
ÏëʵÏÖ ´ÓÎı¾Îļþµ¼Èëµ½AccessÒѾ¶¨ÒåºÃµÄ±í£¬
Îı¾ÎļþÄÚÈÝÊÇ£º
id1,value11, value12,value13
id2,value21,value22,value23
±í×Ö¶Î
id, value0,value1,value2,value3,value4
ʵÏÖ°ÉÎı¾ÀïÃæµÄÄÚÈÝ£¬¶ÔӦÿ¸ö×Ö¶Î µ¼Èëµ½±íÀïÃæ£¬ÓÐûÓбȽϿìËٵķ½·¨¡£
Îı¾ÎļþÀïÃæÃ»ÓÐ ±íÍ·ÐÅÏ¢
Óа¡ ÎÒ¾ÍÊÇÓÃÊÖ¶¯µ¼Èë´óÁ¿txtÊý¾ÝµÄ¡£
н¨Ò»¸öaccess£¬µã»÷ÍⲿÊý¾Ý£¬Ñ¡Ôñtxt£¬µ¼ÈëÄãµÄtxtÎļþ·¾¶£¬ÉèÖÃϾͿÉÒÔÁË µ«ÊÇtxtÊý¾ÝÀïÃæ¸ñʽһ¶¨µÄ¶ÔÆë¡£
Äã¿ÉÒÔÔÚtxtµÄµÚÒ»ÐмÓÉϱíÍ·ÐÅÏ¢£¬ ÔÚµ¼ÈëtxtºóÓиöÑ¡ÏîÊǽ«µÚÒ»ÐÐÉèΪ±íÍ·ÐÅÏ¢µÄ ²»Óõ£ÐÄÕâ¸ö
ÎÒ²»ÊÇÊÖ¶¯µ¼£¬ÊÇÓóÌÐòÀ´ÊµÏÖ£¬
ÔÙÒ»¸ö£¬ÎҵıíʱÌáǰ¶¨ÒåºÃµÄ¸ñʽ£¬²»Äܱ»Ð޸쬵¼ÈëµÄʱºò£¬Îı¾ÎļþÀïÃæµÄÄÚÈÝ ÊÇËùÓÐ×ֶεÄÒ»²¿·Ö£¬²»ÊÇËùÓÐ×ֶζ¼ÓÐÖµ
ÄÇÄ㽫ÉÏÃæÊÖ¶¯µÄ²½ÖèÒ²³É´úÂëÖ´ÐÐÒ²¿ÉÒԵģ¬ ÎÒ¿ìµÄ»° ²»³¬¹ý30Ãë
²»»á²ÅÎÊÄãµÄ°¡
ÌøÐеÄÎı¾Êý¾ÝÖ»ÄÜ×Ô¼ºÐ´³ÌÐò£¬Ò»ÐÐÒ»ÐжÁ³öÀ´£¬ÓÃInsertÂýÂý²å°É¡£
²»ÓÃÌøÐУ¬ÐèÒªÌøÁÐ
Ïà¹ØÎÊ´ð£º
DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿
»úÆ÷Ì«²îÁ˰ɣ¿
ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡
ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂð£¿
Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£
ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......