Hi All,
I am running a VBA module that uses QueryTable object to populate a worksheet. I am getting an error with following line although my sql string looks ok.
strSqlStatement =" select ..,...,...,... from tbl1, tbl2,tbl3, tbl4 where <join conditions>"
Sometimes it works when I remove where clause but even it wasn't consistent. I am accessing Visual Foxpro Tables using DSN.
I am using MS Excel 97 and it uses Ms Query 8.00e .
Any help is much appreciated.
Foxbldr
I am running a VBA module that uses QueryTable object to populate a worksheet. I am getting an error with following line although my sql string looks ok.
Code:
With activesheet.QueryTable(....)
.Sql= Array(strSqlStatement)
...
end with
strSqlStatement =" select ..,...,...,... from tbl1, tbl2,tbl3, tbl4 where <join conditions>"
Sometimes it works when I remove where clause but even it wasn't consistent. I am accessing Visual Foxpro Tables using DSN.
I am using MS Excel 97 and it uses Ms Query 8.00e .
Any help is much appreciated.
Foxbldr