I am trying to load data into an Excel sheet from *.txt file with Schema.ini by using Excel's Data > Get Data > From Other Service > OLE DB but I am getting an error saying as follows:
If I used Microsoft.Jet.OLEDB.4.0 Provider I got the following Error
Operation is not supported for this type of object Error Code=2147467259
If I used Microsoft.ACE.OLEDB Provider I got an error saying:
Error Message: External component has thrown an exception.
The Connection String I gave were:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\DATA;Extended Properties="text;FMT=Delimited;HDR=YES"
provider=Microsoft.ACE.OLEDB.12.0;data source=C:\Data;extended properties="text;FMT=Delimited;HDR=YES"
The Environment I used was: Windows 10 1903 64 bit; Excel 2016 Office 365;
Anybody got this error? if so please help me to resolve this issue.