Thomas Janecek

Thomas Janecek

  • NA
  • 5
  • 4.8k

Mysql table to Access database

Feb 7 2012 4:20 PM
Please help! do I need to synchronize mysql to Access database. preferably via xml. I managed to get mysql database structure:
 
Table name="data">
<Field name="id" type="int(11)" null="NO" key="PRI" default="" autoincrement="false"/>
<Field name="data" type="varchar(255)" null="NO" key="" default="" autoincrement="false"/>
<Field name="data2" type="varchar(255)" null="NO" key="" default="" autoincrement="false"/>
</Table>
 
I do not know how to write the database access.When I need to add a column in MySQL to create and access databases, without losing the original data.I also needed to synchronize data that has changed. many thanks for your help Thomas