>>
>>I don't see any OLEDB providers for Excel 2007. I keep searching...
>
>Jet.4.0
>Cetin
I thought, I posted code with OLEDB, but now I see that it's missing :-). Maybe I didn't posted it :-)
It works with:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;Extended Properties="Excel 12.0;HDR=YES";
as connection string
The Extended properties are important :o))
I got this connection string from
http://www.connectionstrings.com/?carrier=excel2007
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
