English 中文(简体)
MS Access 从文本文件导入问题
原标题:MS Access Import from Text File problems

我正在尝试将一个文本文件导入到一个Access数据库中。这不是我自己编写的文件,但分隔符文本文件的规范已经正确设置,并且使用向导导入文件没有问题。但是,当我尝试使用应用程序本身的导入函数时,导入错误表显示某个字段的“字段截断”错误。如果有帮助就感激不尽。

问题回答

我建议检查您导入的每一列,然后在表格“设计”模式下将其与您的表格列属性进行比较。

共同点 我看到这一错误是:

  1. 进口案文超过外地255个特性限制(在这种情况下,你可以将实地类型改为微米)

  2. 日期字段设置为短日期格式,然后尝试将长日期/时间导入到字段中。

  3. 除了“是/否/正确/错误”之外的文本被导入到“是/否/正确/错误”字段中。

  4. 重复核对你对类似名字的栏目,然后检查进口的数据。 有时,当许多人从事项目和计算数据的工作时,有类似名字的栏目可能会混淆......特别是如果该栏倒塌,其名称就不全。





相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签