import binary files

M

me

Hi,
I would like to know if it is possible to get a binary file into excel and
list the various data in their proper columns


Binary:
@Öá@¨a ¨a ¨a ¨a OÊ@ `Öá@¨a
¨a ¨a ¨a ÀP×@ ãá@¨a ¨a ¨a
¨a äá@¨a ¨a ¨a ¨a


I think the real data are as below demonstrated as a comma seperated.

AAA,20040312,2.5,2.5,2.5,2.5,0
AAA,20040312,2.5,2.5,2.5,2.5,0


I appreciate your help
Andonny
 
D

Dave Peterson

When you posted to the newsgroup, that sample binary data became just regular
text.

I brought it into my favorite text editor and tried to look at in hex and I
couldn't see anything that would even come close to your sample comma delimited
data.

Can you find a text editor that supports hex display? If yes, then maybe you
could pick the fly specks out of the pepper.

If you can find the pattern, you may be able to do it. (I would think it would
be pretty difficult to get perfect.)

If you can find the data, you might want to read this:

File Access with Visual Basic® for Applications
http://support.microsoft.com/support/excel/content/fileio/fileio.asp

=====

On the other hand, maybe someone has written a converted for that type file. If
you post what produced it, maybe someone will jump in. (And the program itself
doesn't support an export option???)
 
Top