I'm trying to figure out why a small bit of VBScript code works fine, while the same (essentially) KiXtart code is giving me an error. Here's the VBScript code...
 Code:
dsn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='c:\test.xls';Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'"
Set conn = CreateObject("ADODB.Connection")
Set cmd  = CreateObject("ADODB.Command")
Set rs   = CreateObject("ADODB.Recordset")
conn.Open dsn


My KiXtart translation...
 Code:
$infile = "c:\test.xls"
$dsn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+$infile+";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'"
$conn = CreateObject("ADODB.Connection")
$cmd  = CreateObject("ADODB.Command")
$rs   = CreateObject("ADODB.Recordset")
$conn.Open($dsn)


The KiXtart code fails with error: -2147352567
"Format of the initialization string does not conform to the OLE DB specification"

Can someone see what I may be doing wrong?
_________________________
silence is golden, but duct tape is silver