0
I first need to know if Access can connect to Mysql database.
From this connection, I need to generate through Access an XML that contains the data of a table of my Mysql database. Later this XML should be sent to a remote server every day (by Webservice probably).
Does anyone know if it’s possible?
It is possible to access mysql database by ODBC: http://www.usandoaccess.com.br/tutorials/configurar-access-com-mysql-via-odbc.asp?id=1. I will not post as answer because I did not test. But it was Google’s first response.
– Celso Marigo Jr
@Celsomarigojr I’ll take a look. The generation part of XML by Access you know of some link on the internet that explains how to do?
– Gustavo Hoppe Levin