How to link my SQl server database to my Excel File

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

I have an Excel file that is already designed and formulas created .

I want to get data from my SQL server database and show the data in my excel file and run the formulas already exists in my excel.

How to connect my excel to the database and place them in predefined place of the data and formulas?

Posted 22-Jul-14 1:32am

TheWebDeveloper

Add a Solution

Comments

Kumarbs 22-Jul-14 7:54am

Are you asking about MySql or Sql Server?

TheWebDeveloper 22-Jul-14 8:30am

sql server

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2014-07-22T01:55:00

Solution 1

The simplest way is to use Excel tools. Have a look here: Connect to (import) SQL Server data[^]

You can always use ADODB + VBA: How To Use ADO with Excel Data from Visual Basic or VBA[^] together with CopyFromRecordset[^] method.

Posted 22-Jul-14 1:55am

Maciej Los

Comments

TheWebDeveloper 22-Jul-14 8:31am

Can I call stored procedures from excel and display records in excel?

Maciej Los 22-Jul-14 8:34am

Yes, by using ADODB.Command. Folow the second link.

TheWebDeveloper 23-Jul-14 4:42am

do you mean using vb.net?

Maciej Los 23-Jul-14 4:52am

No, VBA.

Sergey Vaselenko · Answer 2 · 2014-07-22T23:31:00

Solution 2

You may use Data Connection Wizard[^] of the free SaveToDB Express add-in.

In addition to standard Excel features, it allows:

- connecting to stored procedures;
- specifing WHERE filters for tables and views in a visual mode.

Also you can save data changes back to a database.

Posted 22-Jul-14 23:31pm

Sergey Vaselenko

Comments

TheWebDeveloper 24-Jul-14 2:20am

I will try it. And this is real time? whenever I open the excel it will get me the data real time?

Sergey Vaselenko 24-Jul-14 4:00am

SaveToDB loads all the data into Excel table at once.
But you may configure the AutoRefresh property of the Excel query to update the data periodically.

RealTimeToExcel allows updating data in real time and not only in regular tables.
But you should configure real time formulas like
=RTD("gartle.rtd",,"sql-express","table name","index key value","result data field name")