如何将psv数据导入Microsoft Access [英] how to import psv data into Microsoft Access

问题描述

我正在使用Access 2016，我有一个psv(管道定长的csv)要导入到Access数据库中，当我选择从文本导入时，psv文件不会显示在文件浏览器中:

I am using Access 2016, I have a psv (pipe delimetered csv) to be imported in a Access database, when I select import from text, the psv file doesn't show up in the File Browser:

我也不能直接指定psv:

Nor can I specify the psv directly:

如何将psv导入Access?

How can I import psv into Access?

非常感谢您.

更新:

根据建议，在将psv更改为txt并指定要导入后，我坚持如下:

Per suggestion, after I changed the psv to txt and specify it to import, I stuck below:

其他选项中的不接受管道(或任何字符). (如果这里不接受任何输入，这看起来不像 BUG 吗?)

It DOESN't accept pipe (or maybe any character) in the Other option. (wouldn't this look like a BUG if it doesn't accept any input here?)

谢谢.

推荐答案

在右下角查看，您会看到将视图限制为仅某些扩展名.下拉菜单显示Text Files (*.txt;*.csv;*.tab;*.asc).如果您将该框下拉，则应该有All Files (*.*)或类似名称的选项.

Look in the lower right, and you'll see that you're limiting your view to only certain extensions. The dropdown says Text Files (*.txt;*.csv;*.tab;*.asc). If you drop that box down, there should be an option for All Files (*.*) or something similar.

那真是太奇怪了.起初它不会接烟斗.我单击了一下，然后在其他"框中键入了\字符，然后就可以用管道将其替换.

It was very weird though. At first it wouldn't take the pipe. I clicked around and typed a \ character in the Other box, and then was able to replace it with a pipe.

这篇关于如何将psv数据导入Microsoft Access的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！