Sangeetha

Question: Hi, I am trying to read data from a flat text file using ASP and convert it to Binary, before writing the binary to an MS SQL 2000 DB record.

I know how to read flat files using ASP and also how to write data to an MS SQL 2000 DB. However, I can't seem to find any information on converting ASCII data to Binary in ASP (NOT ASP.NET). Is this possible?

For example, I want to convert

Zmv/ix4T*+hT"U

to

01011010, 01101101, 01110110, 00101111, 01101001, 01111000, 00110100, 01010100, 00101010, 00101011, 01101000, 01010100, 00100010, 01010101

I have found some javascript code to do this via a form which can be seen here JavaScript ASCII Converter but I don't think this will help as javascript is client side and ASP is server side.

I have read a little about using ADODB.Stream here Convert a binary data (BinaryRead) to a string by VBS but do not really understand how I can use this.

Sangeetha

<$.02>And why in the world do you convert from ASCII to HEX to DECIMAL to BINARY? The leap from HEX to BINARY is very straightforward, much more so than from DECIMAL.</$.02>