OLEDB

[AnimeshRawat]

Considering Excel Csv File as a Data Source, I was trying to create a connection using below connection string which I got to know is wrong after many tries. Provider=Microsoft.ACE.OLEDB.12.0;Data Source="D:\SampleCSV.csv";Extended Properties="Text;HDR=YES;FMT=CSVDelimited;" Can someone tell what is the correct connection string for above case?    

[John__Carter]

This is often a good resource https://www.connectionstrings.com/excel/

[AnimeshRawat]

Thanks and surely it's a good resource but it doesn't have any connection string for a CSV file which is what i am looking for.

[John__Carter]

https://www.connectionstrings.com/textfile/   It's been a while since I tried it but I think there is also a way to inform the driver of which datatypes to use by creating a schema.ini file. This isn't a BP thing, it's how the MS drivers work.

[AnimeshRawat]

Ok, Thanks