docmd.transfertext不起作用！ [英] docmd.transfertext don't works!

问题描述

大家好，


昨天我尝试过这个命令：

DoCmd.TransferText acExportDelim，Comma_SEP，" ; myquery"，" D：\Temp \ Temp.txt"


它给了我一个无法找到的错误D：\ Temp \ Temp.txt


这个文件存在我认为应该被新的替换掉！


但转移是' 'nt执行！


我尝试过使用Macro，但同样的pb出现了！


这不紧急，因为我找到了解决方案！就像Access中的一个错误！

Hi all,

Yesterday i''ve tried this command:

DoCmd.TransferText acExportDelim, "Comma_SEP", "myquery", "D:\Temp\Temp.txt"

And it gave me an Error that can''t find "D:\Temp\Temp.txt"

This file exists ant i''ve supposed that should be replaced by new one!

But the transfer was''nt executed!

I''ve tried using Macro, but the same pb appears!

This is not urgent, coz i''ve found a solution! Just like a bug in Access!

推荐答案

嘿Vladi


如果你是D：\驱动器是一个外围驱动器像CD驱动器。它可能无法直接写入。

Mary

Hey Vladi

If you''re D:\ drive is a peripheral drive like CD drive. It may not be able to write to it directly.
Mary

大家好，

昨天我尝试过这个命令：


DoCmd.TransferText acExportDelim，Comma_SEP，myquery，D：\ Temp \ Temp.txt


它给了我一个无法找到的错误D：\Temp \Temp.txt"


这个文件存在蚂蚁我应该用新的替换它！


但转移没有被执行！


我尝试过使用Macro，但同样的pb出现了！


这并不紧急，因为我找到了解决方案！就像Access中的一个bug！

Hi all,

Yesterday i''ve tried this command:

DoCmd.TransferText acExportDelim, "Comma_SEP", "myquery", "D:\Temp\Temp.txt"

And it gave me an Error that can''t find "D:\Temp\Temp.txt"

This file exists ant i''ve supposed that should be replaced by new one!

But the transfer was''nt executed!

I''ve tried using Macro, but the same pb appears!

This is not urgent, coz i''ve found a solution! Just like a bug in Access!

嗨Mary，

确定我的硬盘分为C和D分区：）

Hi Mary,
Sure that my HDD is divided to C and D partitions :)

文件是否锁定在别处。

也许你当时在另一个应用程序中打开它？

否则我不知道。

Is the file locked elsewhere.
Perhaps you had it open in another application at the time?
Otherwise I don''t know.

这篇关于docmd.transfertext不起作用！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！