Extra character with : Shell "cmd.exe /C copy ...."
Posted on 2006-06-17
I have an ACCESS routine that creates creates a csv file of records that then inserts a header record to the top of the file.
To do this, I create the main csv file ("Main.csv") and then the header file ("Header.csv"), and then use the DOS COPY command to append the 'main' file to the 'header' file. The command line is:
Shell "cmd.exe /C copy " & strpath & "Header.csv + " & strpath & "Main.csv " & strpath & "OutputFile.csv".
This appears to work fine, however the resulting file ("Output.csv") has the following character (by itself) on the last line : ""
The "" is not the intermediate file "Main.csv" when I look at it before deleting it.