'检查一个指定路径、指定文件名是否存在。
'若路径不存在则创建之;若该路径存在,则进一步判断该路径下指定文件是否存在,若存在则删除之
Public Sub Initializepath(Path As String, Filename As String)
Dim fs As Variant
If Dir(Path, vbDirectory) = "" Then
Set fs = CreateObject("scripting.filesystemobject")
fs.createfolder (Path)
ElseIf Dir(Path & "\" & Filename) <> "" Then
Kill Path & "\" & Filename
End If
End Sub
SELECT [newfld1], [newfld2] INTO [text;hdr=no;database=c:\temp].临时.txt
FROM
(SELECT left([field1] & " " , 10) as newfld1,format([field2]*100,"0000000") as newfld2 FROM [tablename])
2、如果在同一名录中有相同的文本文件,程序会出错!这个问题怎么解决?可以覆盖原来的吗?
在导出前用以下函数解决
Function CheckText(ByVal strFile)
On Error Resume Next
'Dim strFile As String
'strFile = "c:\temp\临时.txt"
If Dir(strFile) <> "" Then
Debug.Print "已经存在该文件现在删除"
Kill strFile
End If
End Function
SELECT dd1, dd2 INTO [text;hdr=no;database=d:\temp].123.txt
FROM (SELECT EE(A1,TRIM(STR(A2))) AS GD, MID(GD,1,8) as dd1, MID(GD,10,8) as dd2, *
FROM 表4)
模块:
Function EE(RR As String, RR1 As String)
RRA = Left(RR + " ", 8)
RR1A = Right("00000000" + Replace(RR1, ".", ""), 8)
EE = RRA & "," & RR1A
End Function
SQ:
SELECT * ,EE(A1,TRIM(STR(A2))) AS GD,MID(GD,1,8),MID(GD,10,8) FROM 表4;
模块:
Function EE(RR As String, RR1 As String)
RRA = Left(RR + " ", 8)
RR1A = Right("00000000" + Replace(RR1, ".", ""), 8)
EE = RRA & "," & RR1A
End Function