Converting HEX to ASCII

[Mark Wolven]

I have a data profiling tool that stores its results in an ODBC data
file. The results are converted to HEX to conserve storage space. The
reporting tools that come with this data profiling tool suck - they're
canned reports.

So, I am using Access to create more useful reports. However, Access
won't convert from HEX to anything that resembles words. I can use
VEDIT to convert from HEX to Binary/ASCII - but it won't work with
long columns of data...

I know that VB can convert certain datatypes. Is there a way in to
query this column and convert it to binary/ASCII english readable
words?

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Saw this in past month in an Access newsgroup (debug window):

? int("&h0a")
10

I guess you could use it like this in a query:

SELECT Int("&h" & hex_column) As decimal_column
FROM ... etc. ...

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQTZR6IechKqOuFEgEQI5OgCg2YNGwMFLWgHvdXMP7PiHydliY3IAnR6V
6NiEQ1D6zW0iXUmKxLV2paLF
=nf9f
-----END PGP SIGNATURE-----