Using ODBC with Excel for database
Asked By
10 points
N/A
Posted on - 04/07/2012
How do you configure ODBC with Excel to pull data from an SQL database?Â
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
Best Answer
Best Answer
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.
Latest Articles
Best Mirrorless Cameras
Mirrorless camera is the latest obsession among the photographers. The cameras have altogether replaced the traditional DSLR models with their unique and special features.
A mirrorless camera is a light-weighted electronic device device that utilizes...
Improve Your Manuscript Before Publishing: Eight Ways To Help
Every author expects to experience a sense of achievement unlike any other when they complete their manuscript. However, some authors agree that they do not feel fully satisfied looking back at the achievement that...
Top 10 Artificial Intelligence Cryptocurrency
It is a type of digital currency. It can be consumed or negotiated, but it is not issued by central banks or retained in financial institutions. It enables transactions without involving central banks or...
Latest Blogs
Top 10 New Laptop Entrants That Shook The Public
The finest laptops are powerful enough to do your daily tasks, comfortable enough to use all day, and power-efficient enough to ensure you don't run out of battery power unexpectedly. Of course, all these...
10 Facts About The Dark Web
Before getting into knowing the facts, let’s have a brief about the Dark Web. The dark web is the data of the World Wide Web that is accessible only through special software, combinations, or...
Top 10 Latest Steam Cleaner Machines
While looking for a chemical-free way to clear and purify both durable and low grounds in your home, a steam cleaner is an excellent solution. With a spurt of superheated steam, this cleaning equipment...
Latest Tips
Top 10 Internet Monitoring Software
Internet monitoring software keeps a log of all internet activities. You can install this type of software on your computer remotely or by the administrator. An operating console controls this software. This type of...
Top 10 Best Partition Manager Software
A Hard Disk Drive is usually partitioned into various smaller drives for optimization. A partition manager helps make this process easier and more efficient. Here, let’s discuss the top 10 best partition manager software.
1....
Top 10 Best Online Music Production Software
Music production is the initial stage of any song. Music production can be done either in studios or at home using an online music production software. Here, let’s discuss the top 10 best online...
