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;])
Speak using soft and sweet words in case you have to eat them later.