I am working on a file, where I have to pull over 150K rows from CSV file into collection. I am trying doing same using OLEDB VBO. But, I am stuck at setting up the OLEDB CSV connection string, getting attached error. I gone through documentation on portal also but not of much help there as well. Any lead or help here would be appreciated.
Connection String I am using:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&[Data1]&";Extended Properties=\""Text;HDR=Yes\"""
Data1 = C:\\abc.csv
Note: I have installed required Microsoft office Access Database engine 2007.
View attachment 1542865655699.png
Connection String I am using:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&[Data1]&";Extended Properties=\""Text;HDR=Yes\"""
Data1 = C:\\abc.csv
Note: I have installed required Microsoft office Access Database engine 2007.
View attachment 1542865655699.png