Ask Your Question

Revision history [back]

How do I connect to SQL server in a macro in Windows

Be gentle. My coding life began doing operations research programming in Fortran. I have a form in a macro and wish to use info from a user to send back a listbox of items while in calc. My stumbling block is the connect method to SQL via ODBC. The DB is registered in base via ODBC but I have no clue as to the methods available to do this in the macro. Pointing me to to the proper OO documention or an example would be appreciated. benttriker.