Excel Power Query import of MySQL data

Question

I'm hoping there is a simple answer to this as I can't seem to find a solution anywhere.

I am using Excel power query to import some data from a mysql table into an excel file. I only want the data and not all the formatting that seems to be applied whenever I import.

I've gone through all the options and cant seem to find a setting where this can be managed.

What formatting do you mean? Can you be more clear (maybe with some examples)? — Oğuz Yıldız
– Oğuz Yıldız, Commented May 6, 2016 at 18:31

Mike Honey · Accepted Answer · 2016-05-10 22:40:47Z

1

Power Query sets an Excel Table Style (green and white). Select any cell in the table and you can change the Table Style e.g. Table Tools / Design ribbon, Table Styles / Clear.

answered May 10, 2016 at 22:40

Mike Honey

15.2k1 gold badge29 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel Power Query import of MySQL data

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related