Connecting MySQL to SQL!

[Angelo Wolfe]

Hello MySQL community!

I was looking for some assistance regarding connecting to a SQL Server. I have seen many, many different posts and websites that hint at third-party programs and all sorts of different alternative tools. But I feel there should be a simplistic way to do this. If you can point me towards some reading material or have a good suggestion of how to do this, please let me know!

Now, I plan on hosting a MySQL Server / Database on a machine to act as a backend, and will use Microsoft Access 2007 as a front-end. I can set the MySQL server up easily and can verify it connects through linking to it no problem. Here's the issue:

The data I want is being hosted on a SQL Server and is not going to remain on that server. So, I have to find a way to connect MySQL to the SQL Server, append / dump the data into MySQL tables (They can be identical), and run my queries from the static data. Any suggestions? I can find information on how to import MySQL into SQL, but not the reverse.

Thanks in advance!