Hi all,
I need to find a way to query data from an Excel spreadsheet (this file will be updated regularly). We have an Excel file saved on the web server, this file contains information of different users. We need a function allowing each user query their own information from that Excel file then display on a web page.

I am newbie to the DNN, so could you please help to figure out some points:
1. Can I use the Report Module for that task? Actually, I tried to add the Report Module on a web page but I could not change the Data source settings since it requires the HostUser ( Only Host Users (SuperUsers) are allowed to edit these settings). Is HostUSer(SuperUser) is the one who installed DNN on the web server? If I have only Administration role, is there any way that I can run that Report module?

2. I've heard that the User Defined Table module enabling to query data from Excel file. Please suggest to me any UDT modules that I can buy or can use free to solve that problem.

3. If you know other solutions that can help to work with Excel data, please give me some hints...

Thanks a lot,
Hiep

You probably will have to put together several bits of information, but it appears that you can do this.

From the DotNetNuke forums:

In the (REPORT MODULE) SETTINGS, in REPORT SETTINGS, I have put the following items :
Active Data Source: Generic ADO.net Data Source
Ado.net Data Provider : ODBC Data Provider
But I don' know what could I put in Connection String and Parameter Prefix.

What could I do ? Where could I find an Help File

The answers were:

I always use this site to find Connection Strings: http://connectionstrings.com/

The parameter prefix can probably be ignored, unless you plan to use the UserId, ModuleId, TabId, or PortalId parameters provided by the Reports Module. If you do plan to use the parameters, I believe the parameter prefix for Excel is probably "@"

Now, to make this apply to a single person, you'll need to pass in a username or something. I believe that this can be done with the current version of the Reports Module, though I haven't done it.

Securing things so that a user can see only his information, and not information related to others may be more of a problem.

Thanks Joe for your quick answer. However, I could not change the Data source settings in the Report module since it requires the HostUser (error message: Only Host Users (SuperUsers) are allowed to edit these settings).

I was not able to contact the guy who installed DNN on our web server to get the HostUser(SuperUser) role, so is there any way that I can run that Report module if I have only Administration role? Or do you know another solutions enabling to query data from an Excel file?

Thanks.

do you have access to the database tables? If you do then you can create a host user so that you can get full access to the website.

Thanks Lee.