Error 3441 while exporting to text file

P

Ptit Dark

Hi,

With office vista I get an error 3441 "file specification field separator
matches decimal separator or text delimiter"
while doing this
DoCmd.TransferText acExportDelim, , "MyQuery", "C:\...\file.txt", True

I didn't get this error with previous office version.
The regional setting sets dot as decimal separator and semi-colon as text
delimiter (I tried comma as well but it ended the same)

I read it was maybe caused by the 2nd optionnal parameter and it's about a
file but I really don't understand.

If it is too tricky maybe there is another command?

Thanks
 
Top