Problem with TransferText method

[metaltree]

Every time I try the following command:

DoCmd.TransferText acExportDelim, "format_w_tab_header", "query123", "C:\aaa",-1

VBA tells me "Execution error 3027: update impossible, database or object is read-only."

Still, the "query123" object is not a read-only one.

Any clues?

Thanks!

 

[Golom]

Do you perchance have a folder called "C:\aaa"?

If you do then it is attempting to export to a folder and that is indeed impossible.

 

[metaltree]

No, there's no such folder named "C:\aaa".

I changed the name for "C:\aaa.txt" and it doesn't work either.

 

[PHV]

Do you have the right permissions to create a file in the C: drive ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[metaltree]

Yes, I have that right.

I also tried on another drive, and it does the same.

When I put the .txt extension, here is what it says:

Execution error '3011':

Microsoft Jet database engine could not find the object 'aaa#txt'. Make sure that this object exists and that you correctly spelled its name and path.

 

[metaltree]

Okay, I solved the problem.

The Specification Name ("format_w_tab_header") must contain the same field names or types that the object (table or query) contains, otherwise it fails.

Thanks to you all.