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
Ïà¹ØÎÊ´ð£º
_RecordsetPtr CMyAdo::SelectRecord(string &where, string &tablename,string &field, int way )
{
int ret = 0;
_RecordsetPtr pset;
CString sql;
& ......
´ó¸ÅÇé¿ö£º
C#дµÄwinformÓ¦ÓóÌÐò£¬ÒªÇó³ÌÐòÕûÌìÔËÐС£Êý¾Ý±íºÍÊý¾ÝÁ¿²¢²»´ó£¬±í×î¶à15¸ö£¬ÐÂÔöÊý¾ÝÿÈÕ×î¶à1000Ìõ£¬¶øÇÒ±íÖÐÖ»±£Áôµ±ÌìÊý¾Ý¡£
ÐèҪעÒâµÄÊdzÌÐò¶Ô±íµÄ²éѯºÍÐ޸ķdz£Æµ·±£¬¶øÇÒÊǶà¸öÏß³ÌÍ¬Ê ......
dim conn
dim connstr
dim db
dim dbpaswd (Õâ¸öÃÜÂë¼ÓÔÚÄÄ)
db=dbpath&"/"&dbname
connstr="DBQ="+server.mappath(""&db&"")+" ......
ÈçºÎÔÚaccessÊý¾Ý¿â ±íÖвåÈëÒ»¸öеÄ×Ö¶Î?
ÀàÐÍΪÊÇ/·ñ
http://hi.baidu.com/ku_tong/blog/item/393fbe3469eece49241f146a.html
²Î¿¼ÉÏÃæµÄ
SQLÓï¾äÄÜÓÃµÄ ¾ÍÊÇÀàÐͲ»ÖªµÀ false t ......
ÎÒÏÖÔÚaccess±íÖÐijһ×Ö¶ÎA ÓÐÏÂÃæµÄÄÚÈÝ(Ö»ÊǺóÃæµÄ²¿·Ö²»Ïàͬ)
1.http://www.google.cn/search?client=pub-475201884&forid=1&prog=aff&ie=GB2312&oe=GB2312&hl=zh-CN&q=ËûºÍËýµÄÄ ......