技術(shù) 點(diǎn)
- 技術(shù)
- 點(diǎn)
- V幣
- 點(diǎn)
- 積分
- 305
|
各位前輩,小弟新學(xué)ADO,想用ADO連接服務(wù)器上的EXCEL表作為數(shù)據(jù)源,待進(jìn)行某些數(shù)據(jù)處理后,再保存到Access表里面
研究了一下午,剛把連接EXCEL數(shù)據(jù)的步驟弄清楚,可是不知道如何保存成Access表
Dim Connstr As String
Dim cn As New ADODB.Connection
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
add = "D:\yuxgworkcenter\My Documents\SC Database\SourceData.xlsx"
Connstr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & add & ";Extended Properties='Excel 12.0 Macro;HDR=YES';"
cn.Open Connstr
rs.Open "Select * from [基礎(chǔ)數(shù)據(jù)$]", cn, adOpenKeyset, adLockOptimistic
上面是連接的代碼,接下來(lái)我想把記錄集rs保存到當(dāng)前Access數(shù)據(jù)庫(kù)的某個(gè)數(shù)據(jù)表中,數(shù)據(jù)表需要新建,請(qǐng)問(wèn)如何操作?
還望各位前輩不吝賜教,謝謝!
|
|