DAO Problem

[Delta34]

I'm simply trying to send data(in a text box)into an excel CSV type file. It works great except, I can't seem to Edit or Update, I can only Addnew.
When using the Edit method I get:
*******************************************************
"Run time Error 3616"
"Updating data in a linked table is not supported by this ISAM"

**********************************************************
My registry shows that I have the current ISAM for Excel (msexcl35.dll).
I fail to understand why I keep getting this error.
Any suggestions?

[Jimbob]

this is probably no help, but here goes...

As far as I know, the Excel ISAM simply doesnt allow editing. you can only add records with it

i'm at a loss as to why, and what you can do about it, though. sorry!

i hope for your sake someone proves me wrong on this one :-)

[JHausmann]

Does it allow deletions?

[Delta34]

Thanks for the replies.

“Does it allow deletions? “
I’m not sure yet, but it’s my guess that it won’t. I’ll test for that one next.

I did make a discovery though.
Take a look at this clip of code:

For I% = 1 To N%
Data2.Recordset.Edit
Text2.DataField = "in" & (I%)
Text2.Text = Text2.Text & Word(I%)
Data2.Recordset.Update
Next I%
End Sub

As you can see, I’m trying to read in values and concatenate them and store them in excel programmatically. Using the CSV format, I get the above error. Using an excel format I don’t get an error, but no data is copied to the cells either. I’m believe the original error is due, possibly to the DAO object not being able to update text files (i.e. CSV). On the other hand the no data problem, may be due to something in excel itself (i.e. locked file, no updates allowed by multiple users etc.) you know security type stuff. Right now I’m looking into Tools/options in excel.
If any of this rings a bell let me know. I'll settle for a clip of code if got one to spare.
Thanks.