(I assume this is the best forum to discuss data connection issues in Excel? If a moderator thinks it belongs elsewhere, please let me know. Thanks)

I'd like to create a workbook with about 100 identically formatted tables from the same mysql database. (The mysql table has around 200 tables in it).

Each database table has identical labels.

Here's an example schema:

DB name: ospreytwice

Table name: river

Column Names:
  • Datestamp
  • River_Name
  • River_Length


I've been playing around with the DB features all day but can't seem to find a way to configure Excel to make just one DB connection to obtain the values in these separate tables.

Must I need to create a separate query (and connection) for each table? I don't think my db server would allow that. (Also, there are lot of other tables and formulas in the db so efficiency is important).

Obviously I don't want to make the db connection info public, but if it will help you, then PM me and I can send the credentials so that you can see what I'm working with.

Thanks!