HI,
I need to import data from notepad(tabDelimitted) in to SSRS and display as diffrent column in the report.
I am using oledb and using the below connection String:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\RxTools;Extended Properties="text;HDR=No;FMT=Tab Delimited"
But the ouput is coming in a single Column, I need it to split to multiple columns as the notepad has many columns..
Kindly help..