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

accessÎļþ¸ñʽÎÊÌâ

ÔÚvc6Öд´½¨.mdbÎļþ£¬´ò¿ªÎļþºóÏÔʾΪaccess 95Îļþ¸ñʽ£¬ÎÒ×°µÄofficeΪ2003µÄ£¬´´½¨.mdbµÄ·½·¨Îª£º
CString lpDbStruct =  _T("CREATE TABLE Êý¾Ý (".....")");
pDao->Execute(LPCTSTR(lpDbStruct));
pTable=new CDaoTableDef(pDao);
pTable->Open("Êý¾Ý");
pSet=new CDaoRecordset(pDao);
pSet->Open(pTable);
È»ºóÓÃpSet->AddNew();
pSet->SetFieldValue(...);
pSet->Update();
ÕâÑùÉú³ÉºóµÄ.mdbÎļþÊÇaccess 95¸ñʽµÄ¡£
ÔõôÄÜÉú³ÉµÄ.mdbµÄÎļþ¾ÍÊÇaccess 2003µÄ¸ñʽµÄ£¿
ÕâЩ´úÂëûÓаüº¬´´½¨mdbÎļþµÄ°¡¡£
ÄãÄǸöpDaoÊÇÄÄÀïÀ´µÄ£¿

CDaoDatabase *pDao;
pDao->Create("**.mdb");

CDaoDatabase *pDao;
pDao->Create("**.mdb");
CString lpDbStruct =  _T("CREATE TABLE Êý¾Ý (".....")");
pDao->Execute(LPCTSTR(lpDbStruct));
pTable=new CDaoTableDef(pDao);
pTable->Open("Êý¾Ý");
pSet=new CDaoRecordset(pDao);
pSet->Open(pTable);
È»ºóÓÃpSet->AddNew();
pSet->SetFieldValue(...);
pSet->Update();

ÊÇ·ñÓÃaccess2003µÄÒýÇæ£¬½¨Á¢Á¬½Ó

ÊÇ·ñÓÃaccess2003µÄÒýÇæ£¬½¨Á¢Á¬½Ó

ÊÇ·ñÓÃaccess2003µÄÒýÇæ£¬½¨Á¢Á¬½Ó

ÔõôÓÃaccess2003µÄÒýÇæ½¨Á¢Á¬½Ó£¬Ã»Óùý£¬Âé·³¸æÖª

ÔõôÓÃaccess2003µÄÒýÇæ½¨Á¢Á¬½Ó£¬Ã»Óùý£¬Âé·³¸æÖª

ÎÒÊÇÕâô¡°´´½¨¡±.mdbµÄ£º
н¨Ò»¸ö¡°.mdb¡±Îļþ²¢°ÑËüimportµ½VCÏîÄ


Ïà¹ØÎÊ´ð£º

ÈçºÎ´ÓACCESSÊý¾Ý¿âÖÐÒ»´Î²éѯ¶à¸ö±í²¢¼ÓÈëÊý¾Ý¼¯?

ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......

ACCESSÊý¾Ý¿âתDBF

ÒÑÖªÁ½¸öÊý¾Ý¿â£¬·Ö±ðΪBASE.MDB ºÍ BASE2.DBF
×ֶηֱðΪBASE.MDB:NAME NAME2 NAME3 
  A B C  
  D E F  
  ......

ACCESSÎı¾¿ò³¤¶ÈÊǶàÉÙ? - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿

²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û

ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......

jspÒ³Ãæµ¼³öÎÊÌ⣿ÄÜ·ñµ¼³öΪDBFºÍACCESS¸ñʽµÄÎļþ

jsp¿ª·¢µÄʱºòÄܹ»µ¼³öwordºÍexcel£¬µ«ÊÇÊÇ·ñÄܹ»Ö±½Óµ¼³öΪacess¸ñʽ¡¢dbf¸ñʽµÄÎļþ£¿
¸ßÊÖÖ¸µãÏ£¬×îºÃÄܹ»¸ø¸öÀý×Ó£¬Ð»Ð»£¡£¡£¡

javadbfÕâ¸öjarÒ»ÇÐÎÊÌâ½â¾öÁË¡£
ÏÂÔØµØÖ·Îª£ºhttp://sarovar.org/projects/ ......

¹ØÓÚVB.NETºÍMS ACCESSµÄÎÊÌâ

ÎÒдÁËÒ»¸öÈí¼þ£¬ÒªÓõ½ACCESSÊý¾Ý¿â£¬ÎÒÔÙ·ÃÎÊACCESSµÄʱºò£¬ÎÒÐèÒª´Ó±íÀï¶Á³öÒ»ÐÐÊý¾Ý£¬ÎҵijÌÐòÊÇÕâÑùдµÄ£¬SQLSTRING="SELECT * from '" &ME.TEXTBOX1.TEXT &"' WHERE ID = '"& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ