Pls help..DoCmd.TransferText acImportDelim, , "xxx", filepath

[bnath]

I am using transfertext method of the Docmd to basically read the contents of an ascii file whose name & path is g:\apsdata\junk\dna_120104.old.

right when it hits the following line of code,
DoCmd.TransferText acImportDelim, , "tblGr_CallableDNIndexStage", nfile

I get the error "3027 Can't Update. Database or object is read-only."

I even went into registry and added the "old" to be an acceptable format to read the data from

any thought why I might be gettign this error?

thanks
nath

 

[sfreeman]

I think your file name is invalid.

I assume that Access is expecting a .txt file and you are giving it a .old file.

Just for grins, change the extension of the file name to .txt.



Sam_F
"90% of the problem is asking the right question.