topic https://www… in Product Forum

OLEDB

AnimeshRawat — Mon, 22 Jan 2018 16:01:00 GMT

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?

This is often a good…

John__Carter — Mon, 22 Jan 2018 19:07:00 GMT

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

Thanks and surely it's a…

AnimeshRawat — Tue, 23 Jan 2018 14:39:00 GMT

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.

https://www…

John__Carter — Tue, 23 Jan 2018 15:20:00 GMT

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.

Ok, Thanks

AnimeshRawat — Tue, 23 Jan 2018 21:53:00 GMT

Ok, Thanks