I have some automation code that works with the ODBC driver, I am changing to the OLEDB driver and hitting a few problems.

This is the recorded macro from Excel:

With ActiveSheet.ListObjects.Add(SourceType:=0, Source:=Array( _
    "OLEDB;Provider=VFPOLEDB.1;Data Source=C:\DEMO\DEMO.DBC;Mode=Share Deny None;Extended Properties="""";User ID=" _
    , _
    """"";Mask Password=False;Cache Authentication=False;Encrypt Password=False;Collating Sequence=MACHINE;DSN=""""" _
    ), Destination:=Range("$A$1")).QueryTable
    .CommandType = xlCmdTable
    .CommandText = Array("`employees`")
    ...etc.

I have converted to VFP as follows:

loRange = loExcel.Range("A1") 
lcConnectionString = [Provider=VFPOLEDB.1;Data Source=C:\DEMO\DEMO.DBC;Mode=Share Deny None;Extended Properties="";User ID="";Mask Password=False;Cache Authentication=False;Encrypt Password=False;Collating Sequence=MACHINE;DSN=""]
loQueryTable = loExcel.ActiveSheet.ListObjects.Add(0, lcConnectionString, loRange)
loQueryTable.CommandType = 3 &&xlCmdTable
...etc.

It is failing on ListObjects.Add() call with the following error:
OLE error code 0x80070057: The parameter is incorrect.

I am using VFP 9 with the VFP 9 OLE DB Driver against Excel 2007.

Any pointers?