You can link directly to Excel as a table source. How you want to view it in a form is irrelevant.
To do so go to the tables tab, put your mouse in the middle of the window, right click and choose link.
When the next window opens make sure you change the file Type to be looking for Excel...