Delete records from a delimeted file being used as datasource for a linked server using Jet 4.0 OLE DB in ASP.net application
Posted on 2008-11-12
I have a .txt file that I am using as a datasource for a linked server. This is a log file that has 3 fields (date, path and message) that I am viewing in a gridview in asp.net.
Since this log file will grow, I would like to give users the ability to delete records in the file that have a date less then a date they choose in a parameter field.
Here is a sample of my SELECT statement:
Select convert(varchar(10),edate,101) as [Date], ePATH, eMessage from ARLOCKBOX...boaLog#txt
WHERE convert(varchar(10),edate,101) = '11/10/2008'
I don't think Jet 4.0 supports deleting records through a query.
What is the best way to approach this?
Thanks in advance!