Archive for the ‘MS Access’ Category
Wednesday, November 2nd, 2011
Once you launch Infocaptor, you can click on the connect button.
In this example we are using the northwind sample database
Click on connect
Once connected it will open the Option wizard
Since there is no dashboard open, the "Build New Query" is disabled.
Click on the "New Blank Dashboard"
Enter some name for the dashboard ...
Posted in How-to, MS Access | 3 Comments »
Saturday, October 15th, 2011
In this article we will take an Excel source containing scorecard information and convert into dials and speedometer charts.
We will also create few bar trending charts.
Consider the below sample data
Source File: You can download the excel file here
The above excel file tracks few metrics such as safety, quality and revenue. ...
Posted in Excel, How-to, MS Access | Comments Off
Friday, March 26th, 2010
Sometimes, due to some improper setup of Microsoft Excel or incomplete components for Microsoft Office, direct connection to Excel files may not be possible.
Please follow these steps before going forward
http://support.microsoft.com/kb/209805
Verify that the Regsvr32.exe file is in the system folder where Windows is installed.
For example, the Regsvr32.exe file is ...
Posted in Excel, How-to, MS Access | Comments Off
Thursday, June 26th, 2008
You can connect the Dashboard to MS Access using the ODBC and defining the DSN source. This method is described in this section Access Dashboards using ODBC and DSN
Within InfoCaptor, you can connect directly to the access mdb file without the need to define the ODBC Data source name (DSN)
Let ...
Posted in MS Access | Comments Off
Wednesday, May 21st, 2008
We already have a detailed tutorial on how to setup InfoCaptor on the web-server and we receive lot of requests on how to setup or put the dashboards on the web. This server setup guide is quite comprehensive and requires the need to install the repository objects on the database ...
Posted in DB2, Excel, General, MS Access, MySQL, Oracle, SQL Server | 1 Comment »