Sadly, I think there is no easy way. You can have a macro and do it via macro before loading the table to PAD. I think there is some crazy way when you run the SQL query over the Excel table, but never tried it myself.
So, long story short - do it via loop. Super slow, super inefficient, but it works.