|
我用以下代码将文本文件转入到ACCESS表中只转换了一行,谁能告诉我是怎么回事/
Private Sub Command17_Click()
Dim cmd1 As ADODB.Command
Dim introwsadded As Integer
Dim str1
Set cmd1 = New ADODB.Command
With cmd1
.ActiveConnection = CurrentProject.Connection
.CommandText = "SELECT * INTO [2] FROM [Text;FMT=Delimited;HDR=Yes;DATABASE=C:\wq\Day;].[116101#txt] ; "
.CommandType = adCmdText
.Execute introwsadded
End With
str1 = introwsadded & '记录一被追加"
MsgBox str1, vbInformation, "access 2003"
'With cmd1
End Sub
文本文件
转换后的表
|
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有帐号?注册
x
|