?
Solved

linking sql 2008 to ms excel 2007

Posted on 2013-06-04
2
Medium Priority
?
175 Views
Last Modified: 2016-02-11
Hi Experts

if u linked sql data tables to ms excel 2007 and wanted any updates in sql to be reflected in excel....

Whats the best approach to tackling this. ..
0
Comment
Question by:route217
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 2000 total points
ID: 39219406
Unfortunately as far as I'm aware you can not replicate/mirror SQL to EXCEL syncronuosly but...you could design some SSIS package to run it via a SQL job periodicaly to update(refresh) your excel document(s) (assuming sufficient permissions were granted).
0
 

Author Comment

by:route217
ID: 39219954
Thanks for the feedback...
0

Featured Post

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question