Transfer text file

[Steve.]

I am trying to use the Tranfer Text function in a Macro. I have file
C:Test.txt , but when I run the macro I get the error msg - Cannot Update.
Database or Object is read only. The file is a text file with the data in
the same order as the database.

 

[Ken Snell [MVP]]

Perhaps you should add the backslash to the path:

C:\Test.txt

 

[RHONA via AccessMonster.com]

I am having that same problem even though I tried the C:\filename.

Please help......

 

[Ken Snell [MVP]]

Post more details, please.

 

[Ken D.]

I am also having this problem. I am attempting to export a small table in
Delimited format so I can upload to a website. I have my specifications
setup and my path is correct. What am I missing?

 

[Douglas J. Steele]

What name are you trying to use for the file? Access is limited in terms of
what extensions it will allow.

While the following KB articles only mention reading, the information
applies equally to writing:

ACC2000: "Can't Update. Database or Object Is Read-only" Error Message When
You Import Files
http://support.microsoft.com/?id=245407
ACC2000: How to Import a Text File That Has an Extension That Access Does
Not Recognize
http://support.microsoft.com/?id=306144


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)