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.

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