How to link sql-database tables to ms-word?

Question

I have created a sql-database table for bill_payment. Now the user wants to make the changes in ms-word format. He wants to have these changes to be reflected and updated(for the given tuple) accordingly in the sql-database table also. How can I solve this problem?

Answer 1

1) need ODBC driver
2) add a DSN field- enter parametes and sql statement
scroll down to WORD section- subsitute the MYSQL odbc driver for your db
http://www.ced.univ-montp2.fr/mysql/manual-split/manual_ODBC.html

Answer 2

What do you call "sql-database"? There are too many DB engines supporting SQL as DDL/DML...