>Hi,
>
>Cant seem to get the connection string right. Keep getting the 'No named arguments' OLE error message.
>
>I'm using the following:
>

>   cConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + GETFILE()
>		+ [;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";]
>

>
>Any help is greatly appreciated.
>
>Thanks,
>Arriyel

Check http://connectionstrings.com/?carrier=excel

Update. Oops, looks exactly like yours. Let me try.
It brings a Select Data Source dialog for me.

This works:

SQLSTRINGCONNECT([Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\Documents and Settings\Owner\My Documents\Book1.xls;DefaultDir=C:\Documents and Settings\Owner\My Documents;])