Page 1 of 1
[Solved] MS SQL connection
Posted: Mon Feb 07, 2011 11:03 pm
by solecs
Hi there i am trying add a link to a MS SQL database table to a OOo base? We have made some in house search tools that look right at the MS SQL table, but that was with Access 2007 and a ODBC connection. I was wondering how to do it with OOo or if can even be done. I don't know how friendly MS SQL is with OOo.
Re: MS SQL connection
Posted: Mon Feb 07, 2011 11:36 pm
by Villeroy
File>New>Database...
[X] COnnect to existing db
Type: ODBC
Use the same ODBC name as in the other programs, register the database, save the database, add some queries if you like.
In Writer of Calc hit F4 and drag stuff from a table or query into the document.
Re: MS SQL connection
Posted: Tue Feb 08, 2011 12:12 am
by solecs
Great it worked. Thanks a lot.
