将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屋！
