Converting a hex file...

[Matt_Hirst]

I have to read in some rather large hex files, convert them and then populate about 20 tables with the info.

First question is where to start? I seem to remember covering hex when I was at college 14 years ago.

Hope someone can point me to a dummies guide to converting hex files.

regards,

Matt

 

[RuralGuy]

Is your input file truly an ASCII HEX file or is it just a Binary file? I'm pretty sure Access can read a Binary file.

 

[Matt_Hirst]

I am told it is a hex file, not 100% sure though and the guy who gave me the file is unsure.

Is this what I have to do, read it in as a binary file???

Does anyone have any links to a basic guide to hex and converting?

regards,

Matt

 

[RuralGuy]

I strongly suspect the file is simply a binary file. I would read it in as a binary file and see what you have. I've not done this so maybe someone else can offer whatever code is required to accomplish this.

 

[RuralGuy]

If you still need to convert ASCII to Binary then maybe this link is a place to start.
http://www.vbusers.com/code/codeget.asp?ThreadID=582&PostID=1