导出时最大255个字符 [英] 255 Character Max When Exporting

问题描述

大家好


我是这个网站的新手所以请和我一起喝啤酒....


我正在使用MS Access导出查询到xml文件的值。这很好......但是，每个字段最多似乎有255个字符。


我最初将它导出到MS Excel并设法通过''轻松实现拆分字段''（例如，而不是CourseContent - Course Content1和CourseContent2 .....）。


我宁愿使用更专业的方法来执行此任务。


任何帮助都会非常适用


干杯


Gav

Hi All

Im new to this site so please beer with me....

I am using MS Access to export the value of a query to an xml file. This works fine...however, there seems to be a 255 character maximum on every field.

I originally exported this to MS Excel and managed to take the easy way out by ''splitting the fields'' (e.g. instead of CourseContent - Course Content1 and CourseContent2.....).

I would rather use a more profrssional method to perform this task.

Any help will be greatly appriceciated

Cheers

Gav

推荐答案

大家好


我是这个网站的新手，所以请和我一起喝啤酒....


我正在使用MS Access将查询的值导出到xml文件。这很好......但是，每个字段最多似乎有255个字符。


我最初将它导出到MS Excel并设法通过''轻松实现拆分字段''（例如，而不是CourseContent - Course Content1和CourseContent2 .....）。


我宁愿使用更专业的方法来执行此任务。


任何帮助将大大适用


干杯


Gav

Hi All

Im new to this site so please beer with me....

I am using MS Access to export the value of a query to an xml file. This works fine...however, there seems to be a 255 character maximum on every field.

I originally exported this to MS Excel and managed to take the easy way out by ''splitting the fields'' (e.g. instead of CourseContent - Course Content1 and CourseContent2.....).

I would rather use a more profrssional method to perform this task.

Any help will be greatly appriceciated

Cheers

Gav

Access中文本字段的唯一替代方法是备注字段。但是，查询无法很好地解决这个问题。在备注字段上查看本教程。


Mary

The only alternative to a text field in Access is a Memo field. However, this is not handled well by queries. Check out this tutorial on Memo Fields.

Mary

Access中文本字段的唯一替代方法是备注字段。但是，查询无法很好地解决这个问题。在备注字段上查看本教程。


Mary

The only alternative to a text field in Access is a Memo field. However, this is not handled well by queries. Check out this tutorial on Memo Fields.

Mary

正在导出的字段是备注字段。起初我认为问题在于csv文件的最大字符值。但是在切换到xml后问题仍然存在。


我在网上研究它，人们在导出到excel时遇到了同样的问题。解决这个问题的方法是通过vba导出时创建一个excel数组。如果在使用 Application.ExportXML acExportQuery 命令时可以应用这种方法，我主要是在游荡。如果有任何帮助，这里是我用来创建xml文件的代码：

Application.ExportXML acExportQuery，" qryXMLOutput"，filePath& \课程信息 &安培;今天& " .xml"


MsgBox" The File：" &安培; vbCrLf& vbCrLf& filePath& \课程信息 &安培;今天& " .XML" &安培; vbCrLf& vbCrLf& 已成功创建，vbInformation，xml文件已创建


感谢您的帮助


Gav

The fields that are being exported are memo fields. At first i thought the problem lied within the maximum character value of a csv file. But upon switch to xml the problem stayed.

I researched it on the net and people have had the same problem when exporting to excel. The way around this was to create an excel array upon export via vba. I was mainly wandering if such a method could be applied when using the Application.ExportXML acExportQuery command. If it is any help, here is the code i am using to create the xml file:

Application.ExportXML acExportQuery, "qryXMLOutput", filePath & "\Course Information " & today & ".xml"

MsgBox "The File:" & vbCrLf & vbCrLf & filePath & "\Course Information " & today & ".xml" & vbCrLf & vbCrLf & "Has Been Successfully Created", vbInformation, "xml File Created"

Thanks for the help

Gav

Gav


我认为问题出在查询中，与任何出口设施无关。你能发布查询的SQLqryXMLOutput吗？由于查询字段不能很好地处理备忘录字段，我可能会提出另一种方法。


Mary

Gav

I think the problem is in the query and nothing to do with any export facility. Can you post the SQL of the query "qryXMLOutput" as Memo fields are not handled well by queries and I may be able to suggest another approach.

Mary

这篇关于导出时最大255个字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！