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

Access導³öExecl

VB+Access×öµÄϵ統£¬
為·½±ã²é閱與´òÓ¡£¬
Ðè導³ö為execl±í¸ñ£¬
help¡£
環¾³£ºAccess±íÊÇAccess 2000£»

ÍøÉϺܶà,°Ù¶ÈÒ»ÏÂ

¹Ø×¢£¡

´°Ìå´úÂë
VB code:

Private Sub outcstinf_Click() 'µ¼³ö×ÊÁÏΪXLS
Dim i As Integer 'ÐÐ
Dim j As Integer 'ÁÐ
Call openXLT("Custom.xlt")'Custom.xltÊÇÒ»¸öÓëÒªµ¼³öµÄÊý¾Ý±í¸ñʽÏàͬµÄexcelÄ£°åÎļþ
Call OpenConn
sql = "select * from Òªµ¼³öµÄ±í ORDER BY ÓÃÓÚÅÅÐòµÄ×Ö¶Î(Ò»°ãÊDZàºÅ) ASC"
rs.Open sql, cn, 1, 1
If rs.RecordCount < 1 Then
MsgBox "Êý¾Ý¿âÖÐûÓмǼ£¡": Exit Sub
Else
i = 2'´ÓxlsµÄµÚ¶þÐпªÊ¼Ð´Èë(Ä£°åÖеÚÒ»ÐÐÒÑ×÷Ϊ×Ö¶ÎÃû±£Áô)
Do While Not rs.EOF
For j = 0 To rs.Fields.Count - 1 'Ñ­»·Êý¾Ý±íµÄ0ÖÁ×îºóÒ»ÁÐ
xlsheet.Cells(i, j + 1) = rs.Fields(j) 'дÈë(Êý¾Ý±í×Ö¶ÎË÷ÒýÊÇ´Ó0¿ªÊ¼,¶øxlsµÄÁÐʾ´Ó1¿ªÊ¼, Òò´ËÒªj+1)
Next
rs.MoveNext
i = i + 1 'Ìøµ½i+1ÐмÌÐøÐ´Èë
Loop
End If
Call CloseConn
Call closeXLT
sql = ""
End Sub


Ä£¿é´úÂë
VB code:

Public xlApp As Excel.Ap


Ïà¹ØÎÊ´ð£º

ACCESSÆøËÀÎÒÁË£¬MD£¬×Ö¶ÎÖµ²»¶Ô

ÎÒÒª´ÓACCESS²éѯһÐÐÊý¾Ý,Êý¾Ý¿âÀïÓÐ ip£º192.168.2.71£¬192.168.2.55
SELECT COUNT(*) AS num from TreeNode WHERE ([ip]='192.168.2.55')£¬ÄÜÑ¡³öÊý¾ÝÀ´
SELECT COUNT(*) AS num from TreeNode WHE ......

ͬʱ¶ÁÈ¡accessÁ½Õűí

Çë½Ì
ÔÚaccessÖÐ ÎÒÓбí1
id1    id2      id3      id4
  1      2      3        0
  2&nb ......

ÈçºÎͨ¹ýADOʹÓþۺϺ¯ÊýÀ´²éѯ(Êý¾Ý¿âΪACCESS)

_RecordsetPtr CMyAdo::SelectRecord(string &where, string &tablename,string &field, int way )
{
    int ret = 0;
  _RecordsetPtr pset;
CString  sql;
& ......

¹úÇì½ÚÒ»ÎÊ: ÈçºÎÅúÁ¿¸üÐÂAccessÖÐ×ֶβ¿·ÖÄÚÈÝ?

ÎÒÏÖÔÚaccess±íÖÐijһ×Ö¶ÎA ÓÐÏÂÃæµÄÄÚÈÝ(Ö»ÊǺóÃæµÄ²¿·Ö²»Ïàͬ)

1.http://www.google.cn/search?client=pub-475201884&forid=1&prog=aff&ie=GB2312&oe=GB2312&hl=zh-CN&q=ËûºÍËýµÄÄ ......

ÔÚÏß:ÈçºÎ½«DataTableÖеÄÊý¾ÝдÈëµ½AccessÊý¾Ý¿âÖÐ!

  Dim datatable As New DataTable ½¨Á¢µÄÒ»¸öÄÚ´æ±í¡£

ÈçºÎ°Ñdatatable ±íÖеÄÊý¾Ý£¬±£´æµ½ACCESSÊý¾Ý¿â¡£×îºÃÓÐÀý×ÓºÍÔ´Âë

ÓÃoledbµÄÊý¾Ý¿âÁ¬½Ó¶ÔÏóºÍÊý¾ÝÊÊÅäÆ÷µÈ¶ÔÏó£¬Àý
  string&nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ