Hi,
I have a Microsoft Excel Comma Sepearted values file. I need to read data of this file but connection string I am using is not working.
here is my connection string:
Provider="Microsoft.ACE.OLEDB.12.0;data source=c:\test.csv;extended properties='excel 8.0;HDR=yes'"
can some provide some info on what is wrong with this connection?
Thanks,
Go to the complete details ...