Ïò¸÷λ¸ßÊÖÇóÖú¡£
ÎÒÓÃdelphi2009±àдÁËÒ»¸ö¹ÜÀíϵͳ£¬Ê¹ÓõÄÊÇaccessÊý¾Ý¿â¡£ÏÖÔÚÏëͨ¹ý¶àÈËÒ»Æð¼ÈëÊý¾Ýºó£¬½«Êý¾Ýµ¼³ö£¬µ¼³öµÄÊý¾Ý¿â°üº¬¶à¸öÏàͬµÄ±í¡£ÔÙ½«µ¼³öµÄÊý¾ÝÒÀ´Îµ¼È뵽ͬһ¸öÊý¾Ý¿âµÄÏàͬ±íÖУ¬µ¼ÈëÖ´ÐÐÓï¾äÈçÏ£º
procedure TMain.N_ImportClick(Sender: TObject);
begin
Query1.Close;
Query1.SQL.Clear;
Query1.SQL.Text:='insert into PERSON select * from openrowset(''Microsoft.Jet.OLEDB.4.0'',''C:\Documents and Settings\......\×ÀÃæ\PMIS.mdb'';'''';'''',PERSON)';
Query1.ExecSQL;
end;
PERSONΪÊý¾Ý¿âÖеÄÒ»¸ö±í£¬¸ÃÊý¾Ý¿âÎÞÓû§Ãû£¬ÎÞÃÜÂë¡£
µ±ÔËÐгÌÐòÖ´ÐС°Êý¾Ýµ¼È롱ʱ£¬×ÜÊÇÏÔʾ´íÎó£º
General SQL error.
[Microsoft][ODBC Microsoft Access Driver] from ×Ó¾äÓï·¨´íÎó¡£
Áìµ¼´ßµÄ½ô£¬¼±´ý¸÷λ¸ßÊÖ°ïæָ½ÌΪл£¡
ÄãµÄÊý¾Ý¿âÁ¬½ÓʱÊÇÉèÖÃODBCÊý¾ÝÔ´µÄ°É£¿°ÑODBCÊý¾ÝÔ´µÄ·¾¶ÉèÖóÉÒ»ÑùµÄ£¬ÁíÍâÎÒ¾õµÃÖ»ÊÇΪÁ˼ÈëÊý¾Ý£¬¿ÉÒÔÖ±½Ó¶Ôaccess½øÐвÙ×÷¾Í¿ÉÒÔÁË£¬²»ÓÃÕâôÂé·³µÄµ¼À´µ¼È¥
ллһ¥µÄͬ־£¬ÒòΪ¼ÈëµÄÊý¾Ý±È½Ï·±ÔÓ£¬Éæ¼°¶à¸ö±í£¬Í¬Ê±³ÌÐò»¹Óвéѯ¡¢Í¼±íͳ¼ÆµÈ¹¦ÄÜ£¬¼ÓÉϺܶà¼ÈëÈËÔ±²»»áʹÓÃaccess£¬ËùÒÔ²»ÄÜÖ±½ÓÓÃaccessÀ´×ö¡£
ÎÒµÄÊý¾ÝÁ¬½ÓÊÇÉèÖÃODBCÊý¾ÝÔ´µÄ£¬ÏµÍ³DSNϽ¨ÓÐPMIS£¬Â·¾¶ÒÑÉ裬¸Ã³ÌÐòµÄÆäËüÊý¾Ý²Ù×÷ÈçÊý¾ÝµÄ²åÈë¡¢Ð޸ġ¢É¾³ý¾ùÕý³£¡£Ö»ÊÇÊý¾Ýµ¼Èëʱ»á³öÏÖÕâ¸öÎÊÌâ¡£
³ÌÐòÆô¶¯Ê±database1¿Ø¼þÖ±½ÓÁ¬½ÓÊý¾Ý¿âPMIS.mdb£¬ÉÏÃæµÄQuery1.DatabaseName=PMIS
Ïà¹ØÎÊ´ð£º
<?php
include("adodb/adodb.inc.php");
$db = &NewADOConnection("access");
$access = realpath("Data.mdb");
$dsn = "Provider=Microsoft.J ......
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
Êý¾Ý¿âÁ¬½ÓÌáʾÈçϱ¨´í£¬¿´µÄ³öÀ´ÊÇÒ³ÃæÓëÊý¾Ý¿âÁ¬½ÓµÄÎÊÌ⣬ÏÖÔÚÎÒµÄÊÇÏà¶ÔÁ¬½Ó¡£
ÒªÔõô½«Æä¸Ã³É¾ø¶ÔÁ¬½ÓÄØ£¿ÎÒµÄÊý¾Ý¿âÎļþ·¾¶ÔÚ£º
D:\web\db
»¹ÊÇÒªÏÈлл´óÈËÃǰïÖúС°×²ËÎÒ
Microsoft O ......
ËüµÄ¶¨ÒåÊÇÕâÑùµÄ
_CRTIMP __checkReturn int __cdecl _access(__in_z const char * _Filename, __in int _AccessMode);
´ó¸ç£¬¿´¸öº¯ÊýÉùÃ÷¾ÍÄÜ¿´³öËû¸ÉɶµÄ£¿
´ÓÃüÃûÀ´¿´Ó¦¸ÃÊÇÅж ......
DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿
»úÆ÷Ì«²îÁ˰ɣ¿
ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡
ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂð£¿
Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£
ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......