I have a database set up in Access that also includes some linked tables. These tables are from an ODBC source that link to a Unix based system here at work.I'd like to transfer this database and ...

In MySQL it's about 4 seconds vs. about 1.5 minutes. I believe MySQL is creating a temporary table with the entire contents of the subquery where as SQL Server's optimizer is doing something smarter.

Jack Wallen explains how to add data into a MySQL table from the command line.