Page 1 of 1
Connecting and searching in MS SQL Database using macros
Posted: Wed Apr 04, 2018 7:06 pm
by mamkiks
I need to search using macros in writer if some data existing in "MS SQL Server" Database or not
Re: Connecting and searching in MS SQL Database using macros
Posted: Thu Apr 05, 2018 9:37 am
by Villeroy
You dont need any macros. Connect a database document to the database and use the built-in filter tools.
Re: Connecting and searching in MS SQL Database using macros
Posted: Thu Apr 05, 2018 11:41 am
by mamkiks
Villeroy wrote:You dont need any macros. Connect a database document to the database and use the built-in filter tools.
Sorry but I couldn't understand how it works.
I need to use macro to search for value in MS SQL Server Database and return values
Re: Connecting and searching in MS SQL Database using macros
Posted: Thu Apr 05, 2018 5:08 pm
by Villeroy
Then write a macro but do not expect us to do your work.
If you don't even know how to connect a Base document to your database, all hope is lost anyway.
Re: Connecting and searching in MS SQL Database using macros
Posted: Fri Apr 06, 2018 9:33 am
by mamkiks
Villeroy wrote:Then write a macro but do not expect us to do your work.
If you don't even know how to connect a Base document to your database, all hope is lost anyway.
I didn't ask you to do my work
I'm asking about the configuration
In MS Word I'm using ADODB by adding ActiveX reference
then I need to know how to make this using OpenOffice
If you don't want to help me, you don't have to do this
regards.