A family of Microsoft relational database management systems designed for ease of use.
I guess you need import .csv to MySql or link MySql with Access using ODBC.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
We run a online magazine called hk-cityguide.com. It's an online guide with reader voted recommdations for Hong Kong residents looking for the latest arts events, restaurants, and florists and flower delivery.
It is based on wordpress, but we have much of our content and on Microsoft SQL and CSV. Is there a way for us to sync the two in real time? So if we update one, the other also gets updated?
If you need to see our set up, please see https://www.hk-cityguide.com
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I guess you need import .csv to MySql or link MySql with Access using ODBC.
I believe the answer is that there is nothing built-in to SQL Server to sync with a MySQL database. You would have to do the work yourself, or buy "middleware" software to do it for you. Search online for "replication between SQL Server and MySQL".
Microsoft Access, the topic of this forum, can connect to either one, with appropriate ODBC drivers.