Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bi89405
Starting Member
35 Posts |
 Posted - 2011-02-14 : 15:31:39
|
| I would like to create a connection between Excel 2010 and SQL Server that will automatically populate the spreadsheet with the contents of the table whenever I open Excel. Is this possible?Your help is much appreciated!Thanks in advance,Zack H. |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-02-14 : 15:34:16
|
Actually, yes...really easy.Using MS Query (for a query)or a SQL Server connection (for a whole table/view results), you can specify the external data source to refresh on file open in the properties of that connection definition.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
|
|
|
Marrying Excel and SQL Server 2005