Using ODBC with Excel for database

Asked By Maggie Fields 10 points N/A Posted on - 04/07/2012

How do you configure ODBC with Excel to pull data from an SQL database? 

• Status: Open
• Question Views: 950
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Skarbos Jay

Go To Solution

Answered By Pelayo Lyjputo 0 points N/A #110830

Using ODBC with Excel for database

ODBC (Open DataBase Connectivity) is connection running in operation system Windows.

With ODBC, SQL database can interact with other application in windows and also in Microsoft application.

Using ODBC connection data in Microsoft Excel can refresh automatically refer to data in SQL database.

Step by step to setup ODBC in Microsoft Windows :

• Open Control Panel
• Choose System & Security
• Choose Administrative Tools
• Choose Data Sources (ODBC)
• Open Tab Drivers, and choose SQL Servers

About Pelayo Lyjputo

Questions
2

Answers
12

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 04/16/2012
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Skarbos Jay 0 points N/A #110831

Using ODBC with Excel for database

Hi,

Please follow these steps to configure ODBC with excel.

• In the data connection wizard, select ODBC DSN as the connection type and click next.
• You’ll see several types of database including database and Access.
• Select MS Access Database in the list and click on ‘Next’.
• You can then select the Access database you wish to open and select the table you want to open up.
• Now you import data into Excel by clicking Finish in the final step.

Thanks and regards,

Skarbos Jay.

About Skarbos Jay

Questions
5

Answers
204

Best Answers
53

• Vote Up 0 Vote Down

• Posted on - 12/11/2012
• Question Category: MS Excel