Word and a SQL Query/View.

Associate
Joined
30 Sep 2004
Posts
637
Location
Kingswinford
Hello all.

In Excel im able to link a table to an MSSQL Server query and have the spreadsheet update as the table changes, either each time i open the spreadsheet or when i set the refresh rate to a certain timeframe. :D

I have found that in Word you can insert a database and use MSQUERY to link to an SQL view/table but Word dosent seem to be able to dynamically update the table based on changes. To reflect a change i have to delete the table then insert it all over again. :(

Does anyone know if i am missing something here or do i need to venture into VB to dynamically link a SQL table/view in Word ? If so anyone know any a good resources ? :o (You may have noticed i still hold on to the hope its possible).

Thanks

p.s Is it just me or has the search function disappeared when you log in ? :confused:
 
Back
Top Bottom