Using ODBC with Excel for database

Asked By 10 points N/A Posted on -
qa-featured

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

SHARE
Best Answer by Skarbos Jay
Answered By 0 points N/A #110830

Using ODBC with Excel for database

qa-featured

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
Best Answer
Best Answer
Answered By 0 points N/A #110831

Using ODBC with Excel for database

qa-featured

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.

Login/Register to Answer

Related Questions