Export file name problem 1

[meldrape]

Greetings, I have a simple query I need to export as "qte.mat" and I am getting a database or object read only error. When I change the name to "qte.txt" it exports perfectly. Anybody know how I can handle this? it HAS to have the "mat" extension. here's my code:

txtFile="\\servername\qte.mat"
DoCmd.TransferText acExportDelim, "exportspec" , "tblExportEstimate", txtFile, False

Like I said, if I use the "txt" extension it exports fine. Going crazy here. Anybody have any ideas how to handle this with code? Thanks in advance.

 

[Remou]

Hi
I am getting the same problem. Would exporting as text then renaming suit?

OldName = "qte.txt": NewName = "qte.mat"    ' Define file names.
Name OldName As NewName    ' Rename file.

 

[meldrape]

Wow, that totally worked. Many many thanks for your help.