将hex转换为字符串 [英] convert hex to string
问题描述
如何将MySQL数据库的Hext代码输出转换为Access数据库中的字符串输出。目前,该文件以Excel格式输出,我导入到我的访问数据库中。我对vba的了解非常有限,但我对创建查询,报告等知识渊博。我需要一个公共函数,我可以在查询中调用它来执行此转换。
我有这个链接对于本网站
http:// bytes.com/topic/visual-basic-...ert-hex-string
但我一直得到与语法相关的vba错误,我不知道。 ....
How do I convert Hext code output from a MySQL db to a string output in an Access db. Currently, the file is output in Excel format that I import into my access db. I have very limited knowledge about vba but am knowledgeable in creating queries, reports etc. I need a public function that I can call in my query to perform this conversion.
I got this link for this site
http://bytes.com/topic/visual-basic-...ert-hex-string
But I keep getting vba errors that are syntax related and I have no clue.....
推荐答案
就在睡觉前我为你创建了一个小函数,它将十六进制字符串转换为''Plain Olde ASCII''字符串。这里是:
Right before bedtime I created a little Function for you that will convert a Hexadecimal String to a ''Plain Olde ASCII'' String. Here goes:
- 函数定义:
- Function Definition:
嗨ADezii:
我在查询中调用了这个函数。查询在访问时运行并打开,但我用来调用此函数的字段不显示任何字符串...?
Hi ADezii:
I called this function in my query. The query runs and opens up in access but the field that I use to call this function does not show me any strings...?
@sxxgupta
请发布SQL语句。
@sxxgupta
Kindly post the SQL Statement.
这篇关于将hex转换为字符串的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!