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

Çë½ÌdelphiÖÐʹÓÃaccessÊý¾Ý¿â½øÐÐÊý¾Ýµ¼ÈëµÄÎÊÌâ

Ïò¸÷λ¸ßÊÖÇóÖú¡£
ÎÒÓÃ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 ʹÓà ADODB Á¬½ÓAccess µÄÎÊÌâ

<?php

include("adodb/adodb.inc.php");

$db = &NewADOConnection("access");
$access = realpath("Data.mdb");
$dsn = "Provider=Microsoft.J ......

Access²éÕÒÖØ¸´ÎÊÌâ

ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ 
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± 
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......

¹ØÓÚaccessÊý¾Ý¿âÁ¬½Ó¾ø¶Ô·¾¶µÄÎÊÌâÇó½â

Êý¾Ý¿âÁ¬½ÓÌáʾÈçϱ¨´í£¬¿´µÄ³öÀ´ÊÇÒ³ÃæÓëÊý¾Ý¿âÁ¬½ÓµÄÎÊÌ⣬ÏÖÔÚÎÒµÄÊÇÏà¶ÔÁ¬½Ó¡£
ÒªÔõô½«Æä¸Ã³É¾ø¶ÔÁ¬½ÓÄØ£¿ÎÒµÄÊý¾Ý¿âÎļþ·¾¶ÔÚ£º
D:\web\db
»¹ÊÇÒªÏÈлл´óÈËÃǰïÖúС°×²ËÎÒ


Microsoft O ......

_access ÇëÎÊÕâ¸öº¯ÊýÊǸÉÂïÓõģ¿

ËüµÄ¶¨ÒåÊÇÕâÑùµÄ


_CRTIMP __checkReturn int __cdecl _access(__in_z const char * _Filename, __in int _AccessMode);



´ó¸ç£¬¿´¸öº¯ÊýÉùÃ÷¾ÍÄÜ¿´³öËû¸ÉɶµÄ£¿

´ÓÃüÃûÀ´¿´Ó¦¸ÃÊÇÅж ......

DbgridÁ¬½ÓaccessÍ϶¯¹ö¶¯ÌõËÀ»ú£¿

DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿
»úÆ÷Ì«²îÁ˰ɣ¿

ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡
ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂð£¿

Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£

ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ