Hi all. I need to import csv file stored on some http address to MS SQL 2000
DB.
I use vbscript:
-------------------------------------------------------------
set oHTTP = CreateObject("Microsoft.XMLHTTP")

set oStream = createobject("adodb.stream")
oStream.type = adTypeText
oStream.mode = adModeReadWrite
oStream.CharSet = "ISO-8859-1"

oHTTP.open "GET", strSource, False
oHTTP.send

oStream.open
oStream.WriteText oHTTP.responseText

oStream.Position = 2
str = oStream.ReadText -2 ' - GETTING ERROR HERE
-------------------------------------------------------------
I get error while try to get text line from Stream object.
Error msg:
TYPE MISTMACH: '[string: '''']'

whats wrong with this???