VC+ado²Ù×÷accessÊý¾Ý¿â£¬ÎÒÏÖÔÚµÄaccessÊý¾Ý¿âÊÇ·ÅÔÚ±¾µØµÄ¡£ÎÒÏëÇë½ÌÏ£¬Èç¹ûҪͨ¹ývc+adoÔ¶³Ì²Ù×÷·þÎñÆ÷ÉϵÄaccessÊý¾Ý¿â£¬´úÂëÐèÒª×öʲô¸Ä½ø£¿ºÍ²Ù×÷±¾µØaccessÊý¾Ý¿âÇø±ð´óÂð£¿
Ö÷ÒªÊÇÁ´½ÓÊý¾Ý¿âµÄ²¿·ÖÒª×öÐÞ¸Ä
1. ¹²ÏíÎļþ¼ÐµÄ·½Ê½¡£
2.odbc·½Ê½£¬±¾ÖÊ»¹Êǹ²ÏíÎļþ¼Ð¡£
±È½Ï¼òµ¥µÄ¾ÍÕâÁ½¸ö˼ ......
ÔõÑùµ¼³öµ¥ÕűíÖеÄÊý¾Ýµ½Îı¾£¬excel£¬»òÕßaccess¡£×îºÃÄÜÓÃÃüÁ±ÈÈçbpcÃüÁî¿ÉÒÔÂð£¿
ÒýÓÃ
ÔõÑùµ¼³öµ¥ÕűíÖеÄÊý¾Ýµ½Îı¾£¬excel£¬»òÕßaccess¡£×îºÃÄÜÓÃÃüÁ±ÈÈçbpcÃüÁî¿ÉÒÔÂð£¿
bcPÃüÁî¿ÉÒÔ
......
ÏÖÔÚµÄÇé¿öÊÇÓжþ¸öỊ̈߳ºÒ»¸öרߺÔðдÊý¾Ý£»Ò»¸öÊÇÖ÷Ị̈߳¬¸ºÔð¶ÁÈ¡ÏÔʾ£¬ÒÔ¼°Ð޸ġ£
Èç¹û¶¼·ÅÔÚÖ÷Ïß³ÌÀ¾Í²»»áÓÐÏ̵߳ijåÍ»ÁË£¬²»¹ý²»ÖªµÀ¶ÔЧÂÊÓжà´óµÄÓ°Ï죬һ°ãдÊý¾ÝÒª»¨¶àÉÙʱ¼ä£¬°´ºÁÃë¼Æ£¿
4ºË
XP
¾ÍÊÇ˵Èç¹ûÓÃÒ»¸öADOConnection¾Í²»Óÿ¼ÂÇÏß³Ìͬ²½µÄÎÊÌ⣿
ÎÒÏÖÔÚÊÇÖ»ÓÃÒ»¸öConn ......
ËÓÐvc2005·ÃÎÊaccessµÄСʵÀý£¬²»ÊÇvc6.0»ò2003ת¹ýÀ´µÄ£¬
www codeproject com ¿Ï¶¨ÓÐ
ÊDz»ÊÇת¹ýÀ´µÄ²»ÖØÒª°É£¿£¡
http://www.codeproject.com/KB/cpp/howtomix.aspx
°ïÄãÕÒÁËÒ»¸ö£¬
......
VB code:
Public Function ExportExcelSheetToAccess(sSheetName As String, sExcelPath As String, sAccessTable As String, sAccessDBPath As String)
On Error GoTo Err
ExportExcelSheetToAccess = -1
Dim db As Database
' Dim conn As New ADODB.Connection
' conn.Open "Pr ......
¼ÆËã»úÉϲ»×°ACCESSÊý¾Ý¿â£¬ÈçºÎ´´½¨ACCESSÊý¾Ý¿â£®
´úÂëÈçÏ£º
ADOX::_CatalogPtr pCatalog(__uuidof(ADOX::Catalog));
_bstr_t str="Provider=Microsoft.Jet.OLEDB.4.0;data source=C:\\123.mdb";
try
{
&nbs ......