Hi,
I must read the column [Col1] from file1.csv file.
In this file is only one column [Col1] and
in the column [Col1] is only one row with two HEX symbols
(can be from "00" to "FF").
Such file can create with Excel und save in csv format.
But by reading with asp following sets of symbols get wrong result:
"FF" read as "0"
"FB" read as "0"
"F0"-"F9" read as "0"-"9"
"0F"-"9F" read as "0"-"9"
The rest sets of simbols are correct.
Here is my code:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1257">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>New Page 1</title>
</head>
<body>
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "examp1csv"
set rs=Server.CreateObject("ADODB.recordset")
sql="SELECT [Col1] FROM file1.csv"
rs.Open sql, conn
response.write rs("Col1")
rs.close
conn.close
%>
</body>
</html>
Thanks for any help.
Reno
View Cart
