ABArasuraja Balakrishnan Syncfusion Team May 17, 2019 05:11 AM
Thanks for using Syncfusion Products.
We can create datasource using Excel and MSAccess files through inbuild ODBC driver. Please find the below response.
If your requirement is to use excel or MSAccess file as datasource in our ReportServer, then you have to create a DSN using inbuilt ODBC driver for Excel/MS Access. Kindly refer the below steps to achieve this.
1.) Create DSN using ODBC driver to use the excel file as Data Source.
2.) Run the ReportServer and create datasource with ODBC data source connection type with previously created DSN. For your reference we have prepared a video which illustrates how to create a DSN using ODBC driver for Excel file and connect ODBC data source in report server and it can be downloaded from the following location.