If it only a few files that you need to change, NotePad/WordPad can open
these
Otherwise, you can import them into Access. Number of rows is not a concern
then.
Make you changes then export, if you need to keep the .csv format.

NickHK

"Tom Cameron" wrote in message
ups.com...
Hi,

I have a number of CSV files I wish to query using ADO, the only
problem is there are no headers in the CSV files. The obvious option is
to open them in excel and manually enter the headers, howerver there
are more than 65536 records so this is not possible.

Does anyone have any good ideas? any help would be much appreciated.

Thanks,
Tom