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. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

OLEDB Create datasources and datasets

Thread ID:

Created:

Updated:

Platform:

Replies:

144672 May 16,2019 04:37 PM UTC May 17,2019 01:11 PM UTC Report Platform 1
loading
Tags: Report Server
JM
Asked On May 16, 2019 04:37 PM UTC

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

Arasuraja Balakrishnan [Syncfusion]
Replied On 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. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon