I want to get access to a SQL Server database from Microsoft Word. What is the best way to do it and how does it function? Is the best way to do it with ODBC? The Word version is from 1997, and so ADO does not work.
Printable View
I want to get access to a SQL Server database from Microsoft Word. What is the best way to do it and how does it function? Is the best way to do it with ODBC? The Word version is from 1997, and so ADO does not work.
I'd use (in this order) DAO [create an access database with linked tables to SQL server], ODBC, RDO.
I'd pick ODBC over RDO only because I've used ODBC before.