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

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
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.
 
Upvote 0

Forum statistics

Threads
1,216,129
Messages
6,129,047
Members
449,482
Latest member
al mugheen

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
Back
Top