I have code in Excel that uses ADO to read a CSV file. It works IF the
CSV file has certain headings. That's the problem. The CSV file does
not have these headings. So I thought I might first use a query with
ADO to insert the headings I want. THEN query the CSV. So.....how do I
do that? I guess what I'm asking is what query do I use?

Any help for this newbie would be helpful.

tod

It would probably be easier just to create a new file with the correct
headers by first writing out that line and then adding the contents of the
original file.

Not sure you can specify *where* to physically insert a record using ADO,
since that concept is not really relevant to database tables.

Tim

"todtown" wrote in message
...
I have code in Excel that uses ADO to read a CSV file. It works IF the
CSV file has certain headings. That's the problem. The CSV file does
not have these headings. So I thought I might first use a query with
ADO to insert the headings I want. THEN query the CSV. So.....how do I
do that? I guess what I'm asking is what query do I use?

Any help for this newbie would be helpful.

tod