文本文件规范字段分隔符匹配 [英] Text file specification Field Separator Matches

问题描述

我在荷兰有一位客户收到以下错误文本文件规范字段分隔符匹配小数分隔符或文本分隔符当我尝试运行DoCmd.TransferText acExportDelim命令时会发生这种情况。我知道这与他的计算机上有关分隔符的设置有关。有什么办法可以在我的程序中切换设置以适应这种情况。我可能不是很清楚，但我不知道他们使用的确切设置。任何帮助将不胜感激。

解决方案

你可能正在谈论他们使用''''和'''''我们使用'的事实'，'和''。''。 500,000.00将在那里以及欧洲大陆的各个国家显示为500.000,00。


我不确定，但您可以尝试逃避使用中的角色。您还没有与我们分享，我希望它符合您的规范，但如果可以的话，请尝试\，而不是，。

好的，我确定你在欧洲使用''，''和''的方式是正确的。''现在在这里'在我表现出无知的地方，我没有在transfertext命令中设置规范。我从未设置过一个，所以我不知道该往哪里去。如果你能指出我可以找到一些信息的方向，我会很感激。

谢谢

你可以通过手动导入来轻松设置它。在这个过程中保存规范。


2003年它在文件 |下获取外部数据 | 导入...

I have a customer in the Netherlands that is getting the following error "Text file specification Field separator matches decimal separator or text delimiter" This happens when I try and run the DoCmd.TransferText acExportDelim command. I know this has something to do with the settings on his computer regarding the separators. Is there any way that I can switch settings in my program to accommodate this. I''m probably not very clear on this but I don''t know exactly what settings they use. Any help would be appreciated.

解决方案

You''re probably talking about the fact that they use ''.'' and '','' where we use '', and ''.''. 500,000.00 would show as 500.000,00 over there, and in various countries in mainland Europe.

I don''t know for sure, but you can try escaping the character in your use. You haven''t shared that with us, I expect it''s in your spec, but if you can, try "\," instead of ",".

Ok, I''m sure you are correct in the way Europe uses the '','' and the ''.'' now here''s where I show my ignorance I don''t have a spec setup in the transfertext command. I have never set one up so I''m at a loss as to where to go. If you could point me the direction where I could find some information I would appreciate it.
Thanks

You set it up most easily by doing an import manually and saving the spec within that process.

In 2003 it''s under File | Get External Data | Import...

这篇关于文本文件规范字段分隔符匹配的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！