Macro - Query MySQL Database with DSN-less Connection

Anonymous
2010-11-09T21:30:54+00:00

Can anyone help me with writing a macro to query a MySQL database? From Excel?

I can successfully query the remote MySQL db using MS Query and a DSN.  But I need to make it more portable, so multiple users can grab the file and work on it anywhere.

I only need to bring the data into Excel from the MySQL database once each time the file opens.

Any ideas?  I've seen a number of articles about it, but I can't seem to get the syntax correct.

Users are currently using Excel 2003 on Windows XP and Vista (32 bit).

Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments

1 answer

Sort by: Newest
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more