Insert specifiec Data from SQL Server, Choose colums

leitethomas26

New Member
Joined
Mar 29, 2009
Messages
7
Hi
I am new in Excel Practising and i want to ask something i want to do.....
I use Microsoft Excel 2007.
I have a database from SQL Server....

I want to insert some data from a table of my database to Excel file....
Now i choose data,insert from other sources and then insert from sql server and finally i insert my table with all entries to excell and everything is ok.....

My question is if i can choose only 3 colums i want to insert to excel and not all the table???? Can i write some code to excel for that???? Is this possible??? I dont wanna mess with queries in SQL Server...
Can this file refresh every time i put some new records in my database???
Can this project works to older versions of Excel.....????

Please help
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

nirvana_

Board Regular
Joined
Mar 25, 2009
Messages
141
Click Data - Import External Data - New Database query.

You will get the option to run through the wizard to select which fields you want to import. You will need to create a new data source to connect to your sql server.
 

leitethomas26

New Member
Joined
Mar 29, 2009
Messages
7
Ok i think i got it..... Thanks Nirvana... Can i do the same with Excel 2003 or older versions????
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,467
Messages
5,831,802
Members
430,087
Latest member
meagerd

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top