Writing to an SQL File in ACCPAC Macro

[sherlick]

Hi All;

I have written a macro to read data from ACCPAC and write it out to a text file. I would like to change this macro to write to an SQL table. I have not found a way to connect to an SQL database within an ACCPAC macro.

Is this possible? Do I need to add in a reference to the ACCPAC macro? Any guidance/sample code would be appreciated.

Thanks

Stephen

 

[ettienne]

Use ADO or DAO to connect to SQL, you cannot do it otherwise.

 

[sherlick]

Hi Ettienne;

Thank you for the quick response. Do you know the dll I need to add to the Macro so I can get the connection object working?

Thanks

Stephen

 

[jayconverse]

You don't add DLL's, you add a Reference to the project: Microsoft Activex Data Objects 2.5 Library (or higher).

Jay Converse
IT Director
Systemlink, Inc.