linking sql 2008 to ms excel 2007

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. ..
route217Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
lcohanConnect With a Mentor Database AnalystCommented:
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
 
route217Author Commented:
Thanks for the feedback...
0
All Courses

From novice to tech pro — start learning today.