我已经把ACCESS数据库里的一个表导入到Excel文件,但不知如何用代码实现另存为带制表符的文本文件.
savepath="student.txt"
Dim xlBook As New Excel.Workbook '定義Excel工作簿對象
xlBook.SaveAs savepath这样生成的文本文件直接打开格式是乱码形式的.
savepath="student.txt"
Dim xlBook As New Excel.Workbook '定義Excel工作簿對象
xlBook.SaveAs savepath这样生成的文本文件直接打开格式是乱码形式的.
Dim rs As New ADODB.Recordset, fl As ADODB.Field
rs.Open "select * from goods", CurrentProject.Connection, adOpenStatic, adLockReadOnly
Do While Not rs.EOF
For Each fl In rs.Fields
Print #1, fl; Chr(9);
Next
Print #1,
rs.MoveNext
Loop
Close #1