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

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 05:11 AM

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.
Live Chat Icon For mobile
Up arrow icon