将数据导入access
请问怎样在vb中先将5个text文本框中动态数值保存在access数据库中 再将数据导入excel
求代码 详细点 我是小白 帮帮忙啊
[解决办法]
dim Cnn As New ADODB.Connection
dim rs as new adodb.recordset
Cnn.Open "provider=microsoft.jet.oledb.4.0;data source=D:\access.mdb;persist security info=false"
rs.open "select * from table1",cnn,adOpenStatic, adLockOptimistic
rs.addnew
rs.fields(0)=text1.text
rs.fields(1)=text2.text
...
rs.update
rs.close
cnn.close