Solved Error msg resolution (1 Viewer)

[KenHigg]

When I run this:
=================================================

=================================================

I get this:

Any suggestions? The cvs does not exist yet...
>>>Thanks for any help <<<

 

[Gasman]

Firstly that should be csv surely?
Secondly message appearsto be self explanatory. Google the transfertext command.
Here, I will do it for you.

DoCmd.TransferText method (Access)

Office VBA reference topic

learn.microsoft.com

 

[KenHigg]

Yeah, I posted the wrong code and error msg, sorry. I did have the table name in the docmd. Here is what I was getting:

And it was the csv causing the issue.

fyi - when you pull up the explanation for the error msg 3027 is says nothing about the file name extension issue. Why is a .cvs read only when a .csv is not...?

btw - I did pull up the ref you posted before I came to the forum thank you. The 'Here, I will do it for you.' is a bit condescending, not really in the spirit of helping others?

 

[Gasman]

Well I didn't know that did I? and posting it for you was to save you doing so, and perhaps not even get the same results?

Plus I was working with a self explanatory error message, which now turns out, not even to be the correct one?

 

[KenHigg]

Yeah, I mucked up the entire thread by posting wrong screen shots, sorry. And thanks for your help...

 

[Gasman]

I was curious about the extension issue, and I tried with a cvs file, and got the same read only message.
No clue as to why TBH, so I have learnt something new. Mind you with my memory, I'll promptly forget it.

I am going to ask the experts though.

 

[KenHigg]

I wonder if windows maintains a list of read-write/read-only file extensions...

 

[Gasman]

See this thread.

Extension mistyped causes Read Only error

Hi all, In trying to assist another member in this thread https://www.access-programmers.co.uk/forums/threads/error-msg-resolution.327161/#post-1871024 I inadvertently solved the problem, by mentioning that the extension of the output file did not appear to be correct. However I was curious as...

www.access-programmers.co.uk