Excel ODBC – Access ODBC

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 typically found in C:WindowsSystem or in C:WinntSystem32.
Click Start, and then click Run.
In the Run dialog box, type the following command in the Open box.

Note The path of Regsvr32.exe and the name and the path of the DLL may be different on your computer. The following command registers the Excel ISAM:

Regsvr32 c:winntsystem32msexcl40.dll

or

Regsvr32 c:windowssystem32msexcl40.dll

Note Another method of registering DLLs is to use Windows Explorer to find the DLL.

Double-click the DLL. In the Open With dialog box, click Regsvr32.exe, and then click OK.

This creates a permanent association of all DLLs with Regsvr32.exe. You can register other unregistered DLLs by double-clicking them.

try the above step and go back to infocaptor and connect again. If it does not work then follow the steps below.

This tutorial provides an alternative method to connect to the Excel Files. This method also applies to any new format of Excel Files or Microsoft Access databases (ie. mdb or .accdb)

Steps to Create DSN for ODBC connection

1. Click on the Start menu and click on the Control Panel

Image

 

2. Click on the "Administrative Tools".

NOTE: You may need to "Switch to Classic View" in windows Vista or newer version of your windows operating system

Image

 

3. Click on the "Data Sources (ODBC)" setup icon

Image

 

4. Click on "Add"

Image

 

5. Select .xls, .xlsx .xlsm .xlsb option if you are using the latest Excel version and format of Excel

Image

6.We will select the normal .XLS version since this northwind.xls file was created using old format

Image

7. Give a short and simple name to this DSN entry

Image

Image

 

8. Now select and point this DSN name to the appropriate Excel file

Image

9. Image

10. select the file and click OK. Close all the dialogs.

11. Now go back to InfoCaptor connection wizard

Image

12. Select the "ODBC" option now instead of the "Excel" option

Image

13. Give some simple name to this connection so that InfoCaptor can easily remember it

Image

14. Type the ODBC name that was defined in the ODBC DSN setup screen previously

Image

15. Image

Click on the Connect button and then you can proceed the remaining of this tutorial after the connection part

Free Dashboard PDF Tutorial

Join InfoCaptor and Get Free Dashboard Software

Posted in Excel, How-to, MS Access


Would you like to build your dashboard now?

If so, click to buy now, including 60 minutes of dashboard development for free!