We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
  1. Home
  2. Forum
  3. Report Platform
  4. OLEDB Create datasources and datasets
If you became a customer of the Syncfusion Reporting Platform or the Report Viewer, Report Designer, or Report Writer components before October 2019 and have questions related to those products, you can request support through our forum system. However, please note that this support system is only for existing customers who are still using the Syncfusion Reporting Platform or its components and not for new customers looking for reporting products from Syncfusion.

For new customers or those with general reporting questions, we recommend contacting our support team at https://support.boldreports.com/, which is a separate brand created by Syncfusion for its reporting solutions. Our team will be happy to assist you with any questions you may have.

Thank you for choosing Syncfusion for your reporting needs.

OLEDB Create datasources and datasets

The report server uses Access (.mdb) or Excel (.xlsx) as the datasource.
Create datasources and datasets.
How can I set it up?

1 Reply
AB Arasuraja Balakrishnan Syncfusion Team May 17, 2019 01:11 PM UTC

Hi jiamingliang 

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. 


3.) You can use the following connection string and query to retrieve the data from excel file via ODBC connection. 

ConnectionString : Dsn = ExcelDataSource (Enter the “datasource” name that you have configured in ODBC)  
Dataset Query : select * from [Sheet1$]; (Enter the “Sheet Name” of the excel to retrieve the data) 

Please let us know if you need further assistance on it. 
 
Thanks, 
Arasuraja B. 


Loader.
Up arrow icon