Prev: update text file
Next: waiting for function/process to finish...
From: Daron on 25 Jun 2008 14:06
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,
adLockBatchOptimistic

'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.
 | 
Pages: 1
Prev: update text file
Next: waiting for function/process to finish...