Dynamic / Automatic SQL Data in Word

[Jeremy Clark]

Hello - I work for an adult school here in CA. This
summer we have a "major" web dev project underway. One of
the main tasks this summer is to bring our course
catalogue online. We have accomplished the web side by
creating a relatively extensive SQL database to house all
class information. Now, the tricky part, we are trying to
avoid dual entry of data at all coast. We have written a
nice asp page to input class information into the
database. Now, I need to extract that data into in a
printable and easily read format. We would like to do it
dynamically.

Is there a way we can get Word to connect to a SQL
database and dynamically /automatically pull new content
and records? We have successfully pulled data from the
SQL server using MS Query and SQL Statements, however the
data does not seem to be dynamic - meaning when new
records are added the document will not update. Any help
will be appreciated. I have added the SQL statement we
are using below

SQL STATEMENT:

SELECT s.Title, c.Description, c.Credit, c.Days, c.Times,
c.Location, c.Fee, t.last_name, t.first_name
FROM Course as c, Subject as s, Teacher as t
WHERE c.Sys_Subject = s.Sys_Subject
AND c.Sys_Teacher = t.Sys_Teacher
AND c.Sys_Subject = 13
AND c.Active = 1


Thanks,
Jeremy

Jeremy D. Clark
IST Technician
Bakersfield Adult School
Kern High School District

 

[Word Heretic]

G'day "Jeremy Clark" <[email protected]>,

you would need to use the AutoOpen of the document to re-trigger a
population run.

Hello - I work for an adult school here in CA. This
summer we have a "major" web dev project underway. One of
the main tasks this summer is to bring our course
catalogue online. We have accomplished the web side by
creating a relatively extensive SQL database to house all
class information. Now, the tricky part, we are trying to
avoid dual entry of data at all coast. We have written a
nice asp page to input class information into the
database. Now, I need to extract that data into in a
printable and easily read format. We would like to do it
dynamically.

Is there a way we can get Word to connect to a SQL
database and dynamically /automatically pull new content
and records? We have successfully pulled data from the
SQL server using MS Query and SQL Statements, however the
data does not seem to be dynamic - meaning when new
records are added the document will not update. Any help
will be appreciated. I have added the SQL statement we
are using below

SQL STATEMENT:

SELECT s.Title, c.Description, c.Credit, c.Days, c.Times,
c.Location, c.Fee, t.last_name, t.first_name
FROM Course as c, Subject as s, Teacher as t
WHERE c.Sys_Subject = s.Sys_Subject
AND c.Sys_Teacher = t.Sys_Teacher
AND c.Sys_Subject = 13
AND c.Active = 1


Thanks,
Jeremy

Jeremy D. Clark
IST Technician
Bakersfield Adult School
Kern High School District

Steve Hudson

Word Heretic, Sydney, Australia
Tricky stuff with Word or words for you.
Email: (e-mail address removed)
Products: http://www.geocities.com/word_heretic/products.html
Spellbooks: 728 pages of dump left and dropping...

The VBA Beginner's Spellbook: For all VBA users.