December 3rd, 2012, 11:33 AM
Adding text to a file using VBA
I have some code that exports a table as a .csv file (running an append query to move selected records to a temp table then using DoCmd.TransferText).
I want to add a line of text at the start of the file.
One way I think I could do it is by using FileSystemObject to read the entire file and write it to a new file, but with a new line at the top. I don't want to do this as it seems like a very inefficient method - particularly as the .csv may be many thousands of lines.
I originally 'solved' the problem by having an append query add a line of text to the first field in the table before the main query runs. I thought this was a great idea until I realised that the line would also contain commas for each blank field afterwards, which is a problem.
Is there a better way of doing it?
Last edited by Charlie_B; December 3rd, 2012 at 11:36 AM.
February 2nd, 2013, 06:53 AM