I am tasked with figuring out a solution to this... I have a DB server running SQL 2008. I need to on a regular basis export a single table and then copy that table into a MySQL DB running on our ...

forewarning - I have pretty much avoided databases in my career<BR><BR>1. I am looking to do the aforementioned migration to a express 2005 server, but the express 2005 toolset is insanely crippled, ...

This is a demo file for creating DSN-less MySQL connections from an MS-Access application. While you'll still need to download and install the MySQL ODBC connectors, you won't need to create a DSN ...