Adding text to a file using VBA

[Charlie_B]

Hi all,

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?

Cheers,

Charlie

[softwareskill]

Here's a simple explanation on how to read data from and write data to text file in asp.net How to read data from and write data to text file in Asp.Net | Free Dotnet Applications