|
|
i have created the excel table with the figures same as my database and so whenever my database is updated with the new figures, my excel table must also automatically updated. how can i go about doing it or is there any website i can refer...
|
|
|
|
Is the excel spread sheet online?
If so you could think about creating it `on the fly` by reading it from the database (see the article on this site that explains how to do this.
Regards
DAvid
|
|
|
|
where to find the information ?
|
|
|
|
Another resource is of course Microsoft.
http://support.microsoft.com/default.aspx?scid=kb;en-us;278973
Are your SQL Server and Excel file on the same network? If so, perhaps you`d rather set up the Excel file to be linked directly to the SQL Server data? I`m not familiar with how to do this, but you may research this option if it sounds applicable. Sorry I wasn`t able to give more specific details at this time.
|
|
|
|
|
Archive Import (yingz) 
Troy Wolf
