从XML导入到Access数据库时为什么数据会被截断 [英] Why data is truncated when importing from XML to an Access database

问题描述

当我将XML导入Access时，Access数据库中的XML列之一被修剪.有没有办法为每个指定数据类型 导入Access时输入列?

When I import the XML into Access, One of the XML columns is trimmed in Access database. Is there any way to specify the data type for each column when importing into Access?

我试图更改列的大小，但它只允许255个字符，但是我的XML列超过255个.我想将XML文件复制到Access数据库，然后从Access数据库复制到SQL.

I tried to change the column size but it allows 255 character only but my column in XML is more than 255. I want to copy an XML file to Access database and from Access database to SQL.

请让我知道该方法，我必须从一个xml创建两个表

Please let me know the method and i have to create two tables from one xml

我尝试使用直接从xml导入到sql.如果单击链接，我会得到一个链接，一个查询窗口将打开.现在我必须创建两个表.您能帮我在开放XML查询中使用过哪个标签.

I have tried using directly importing from xml to sql. i got one link if i click link one query window will open . Now i have to create two table . could you help me which tag i have used in open XML query.

推荐答案

是的，MS Access受到限制.但是有解决办法.让Access创建一个表.但是，通过重命名较旧的表来创建表的结构，现在只需将数据追加到具有Structure的新表中即可.在此之前，将数据类型更改为LONGText.就是这样:)

Ya , there is a limitation to MS Access. But there is solution . Let the Access create a table . But create a structure of table by renaming the older one and Now just Append the data to the New one which is having Structure . before that change data type to LONG- Text. That's it :)

这篇关于从XML导入到Access数据库时为什么数据会被截断的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！