I am trying to importa a file into a mysql database. The file is a comma delimited text file. I'm having some trouble with the VBScript at this pont... I get a type mismatch at this line.
datcols=split(dat,",")
Here is the rest of the code. Does anyone see the problem?
while not objTS.AtEndOfStream
dat = objTS.ReadLine
datcols=split(dat,",")
mySQL ="UPDATE order SET auth = datcols(1) where order_id = datcols(0)"
conn.Execute mySQL
wend
Thanks!
datcols=split(dat,",")
Here is the rest of the code. Does anyone see the problem?
while not objTS.AtEndOfStream
dat = objTS.ReadLine
datcols=split(dat,",")
mySQL ="UPDATE order SET auth = datcols(1) where order_id = datcols(0)"
conn.Execute mySQL
wend
Thanks!