十六进制到文本（ascii）转换 [英] hex to text(ascii) conversion

问题描述

我有一个我导入访问的xml文件，我有两个十六进制格式的字段。是否可以将这些字段转换为访问中的文本？我想在导入之后这样做或者我应该在导入时这样做吗？


谢谢，


还要感谢之前的所有帮助，非常感谢。

I have a xml file that I import to access and I have two fields that are in the hex format. Is there away to convert those fields to text within access? I am thinking to do it after the import or should I do it on import?

Thanks,

Also thanks for all previous help, much appreciated.

推荐答案

那里。


将十六进制数导入到表的文本字段中（tbl.txtHex在示例中）。运行以下查询：

Hi, there.

Import hex number to a text field of a table (tbl.txtHex in the example). Run the following query:

展开 | 选择 | Wrap | 行号

谢谢我试一试。我将回发成功或失败。

thanks i''ll give it a try. I will post back success or failure.

我认为它是一个16位十六进制数。该字段有1024个字符。我想这会使查询无效或我错过了什么？如果该查询仍然适用，那么我得到的错误是它不可更新。

it is a base 16 hexadecimal number i think. The field has 1024 characters. I guess that makes that query not work or am i missing something? If that query would still apply, then i get the error that it is not updatable.

这篇关于十六进制到文本（ascii）转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！