CODEWITHSUNDEEP
sql-server
Gopal
Gopal

Reputation: 11972

How to import a data from sql server to excel?

I want to get a date from sql server into excel

How can i do it manually?

Upvotes: 0

Views: 909

Answers (2)

anishMarokey
anishMarokey

Reputation: 11397

Try this

Data - >
import External data -> 
import data -> 
select NewSource -> 
what kind of data source do you want to connect to?(select Microsoft SQL Server) -> 
next (authentication server) -> 
next ->  
select the database that contains the data you want? (select  your database) -> 
select the table and click Finish

Upvotes: 4

d3vdpro
d3vdpro

Reputation: 2977

export it into csv format and then open it through excel...short and nice

Upvotes: 0

Related Questions