Ïò¸÷λ¸ßÊÖÇóÖú¡£
ÎÒÓÃ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
Ïà¹ØÎÊ´ð£º
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......
ÎÒÔÚÄ£¿éÀï×Ô¶¨ÒåÁËÒ»¸öº¯Êý:stradd()
¿ÉÊÇÔÚadoquery1.sql.add('select stradd(author) from book');
ʱÌáʾstradd䶨Òå...
Õâ¸öÎÊÌâÓÐʲô°ì·¨¿ÉÒÔ½â¾öµÄÂð? ·Ç³£¸Ð¼¤!
(ÔÚA ......
±í½á¹¹£º
ProductSeriesID ×Ô¶¯±àºÅ
ProductSeriesName Îı¾
ProductSeriesRemark ±¸×¢
Ö´ÐÐÇ°
ProductSeriesID ProductSeriesName ProductSeriesRemark
2 LVϳµ¶ÏµÁÐ LVϳµ¶ÏµÁÐ
3 ÎÙ¸ÖÉá ......
MFCÓÃDAOÁ¬½ÓaccessÊý¾Ý¿â
ÍùÊý¾Ý¿âÀï²åÈëÊý¾Ý£¬ÈçºÎŪ£¡£¿
Connection strings for Access
http://www.connectionstrings.com/access
ÒýÓÃ
C/C++ code
_ConnectionPtr m_pConnection;
&n ......
ËüµÄ¶¨ÒåÊÇÕâÑùµÄ
_CRTIMP __checkReturn int __cdecl _access(__in_z const char * _Filename, __in int _AccessMode);
´ó¸ç£¬¿´¸öº¯ÊýÉùÃ÷¾ÍÄÜ¿´³öËû¸ÉɶµÄ£¿
´ÓÃüÃûÀ´¿´Ó¦¸ÃÊÇÅж ......