Tables continuing from page to page?

Hi all! I create reports where I pick up comments/text from an Excel sheet and literally copy and paste it into my InDesign report. Normally there aren't that many, so my issue isn't an issue. But once in awhile, I get a long spreadsheet... so the table goes on for several pages. I've always create it in a clunky way... I have a template table that fills the page. I copy and paste into it. If it is too long for one page, I copy the table, paste it on to the next page... delete the rows I had on the previous page... and on and on. I've finally decided I need to figure out how to do this in a better way. IS there a way to have a table continue from one page to the next? And if so, how do I make that happen? Thanks so much.