OLEDB Create datasources and datasets

[JM]

The report server uses Access (.mdb) or Excel (.xlsx) as the datasource.

Create datasources and datasets.

How can I set it up?

[Arasuraja Balakrishnan]

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. 

http://www.syncfusion.com/downloads/support/forum/144672/ze/ODBC_D~11101960572.zip 

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.