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
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

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????
 

Watch MrExcel Video

Forum statistics

Threads
1,122,819
Messages
5,598,289
Members
414,223
Latest member
Accountant2B

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