Cannot create and populate list type System.Data.OleDb.OleDbErrorCollection.Path

[Neya (Neya Murali)]

Hello,
When i try to extract the subject,date and attachment name from the mail and put it in a datatable and then write it on an excel sheet,i get an error"Cannot create and populate list type System.Data.OleDb.OleDbErrorCollection.Path ‘$values’,line1,position 164."
Please help me out!!!

[Dominic]

@neya,
Check if this could solve your problem.

Connection string for excel

Hi @debashishforyou, Kindly check an example that basically works with both .xls and .xlsx files. Excel - Execute Query.xaml (8.0 KB)

regards,
Dominic