Hi Naomi,

I have that one working too. I use that one to extract the sheet names.

I use the other because I need the 'Extended Properties' to get around the PRB: Excel Values Returned as NULL Using DAO OpenRecordset (Microsoft Knowledge Base: 194124 (http://support.microsoft.com/kb/194124/EN-US/)). See also http://support.microsoft.com/kb/257819.

Regards,
Arriyel

>>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;])