I'm pulling data from a mysql database into Excel. The db has about 20 tables, each with identical schemas:
I'm able to create a table using query/edit/source/navigation with this code:
I've explored the edit/navigation menus hoping to find a way to add new columns from table2, table3 etc. The new columns don't need to show the timestamp but they do need to show Value1 and Value2
It seems that modifying the query would be more efficient than starting from scratch each time, making one db connection for every table I need.
What would be the best way to add columns from these other tables? (and to be clear, these columns would occupy identical rows (dates) in one worksheet.)
Thanks so much!
Bookmarks