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ÏîÄ
Ïà¹ØÎÊ´ð£º
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
ÒÑÖªÁ½¸öÊý¾Ý¿â£¬·Ö±ðΪBASE.MDB ºÍ BASE2.DBF
×ֶηֱðΪBASE.MDB:NAME NAME2 NAME3
A B C
D E F
......
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿
²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û
ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......
jsp¿ª·¢µÄʱºòÄܹ»µ¼³öwordºÍexcel£¬µ«ÊÇÊÇ·ñÄܹ»Ö±½Óµ¼³öΪacess¸ñʽ¡¢dbf¸ñʽµÄÎļþ£¿
¸ßÊÖÖ¸µãÏ£¬×îºÃÄܹ»¸ø¸öÀý×Ó£¬Ð»Ð»£¡£¡£¡
javadbfÕâ¸öjarÒ»ÇÐÎÊÌâ½â¾öÁË¡£
ÏÂÔØµØÖ·Îª£ºhttp://sarovar.org/projects/ ......
ÎÒдÁËÒ»¸öÈí¼þ£¬ÒªÓõ½ACCESSÊý¾Ý¿â£¬ÎÒÔÙ·ÃÎÊACCESSµÄʱºò£¬ÎÒÐèÒª´Ó±íÀï¶Á³öÒ»ÐÐÊý¾Ý£¬ÎҵijÌÐòÊÇÕâÑùдµÄ£¬SQLSTRING="SELECT * from '" &ME.TEXTBOX1.TEXT &"' WHERE ID = '"& ......