Using ADO to insert values into CSV file
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 |
Using ADO to insert values into CSV file
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 |
All times are GMT +1. The time now is 06:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com