• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

update text file



I need to update a text file.

My current attempt is to create a recordset from the text file, which
I am thinking I would have to disconnect to make it updatable. Here is
my code sample:

sql_Regents = "SELECT * FROM [" & str_PlanName & ".csv]"

'Connect to the text file, and create our base RecordSet
Set rs_regents = CreateObject("ADOR.RecordSet")
rs_regents.Open sql_Regents, strCon', adOpenForwardOnly,

'disconnect the recordset to update it
Set rs_Regents.ActiveConnection = Nothing

str_PlanName & ".csv" is an existing file. I get the following error
at the "Set rs_Regents.ActiveConnection = Nothing" line:
Operation is not allowed when the object is open

Any help or alternatives would be appreciated.

My Computer

Users Who Are Viewing This Thread (Users: 1, Guests: 0)