Using Access Connection with Excel Table

[Vaslo]

Hi All,

Has anyone seen a discussion on using the Excel Table feature (the one that used to be List) with Access? I like the auto-scaling of the tables and would like to keep the connection to the Access Database. That said, I can't find any detail that this can be done. I've had to bring link the Access table in one tab and then reference it from another, or cut and paste it over. Has anyone done this or can you recommend another approach? The data updates daily so it's easier to keep it in Access (362k lines and I need them grouped, not all the lines) and just bring over what I need already grouped.

Thanks.

 

[SpillerBD]

"... THE NAMES HAVE BEEN CHANGED TO PROTECT HE INNOCENT..."
It should still be there, just different in name (and location) depending on which version you had most actively used it.
I was having trouble figuring what side is which... Excel pulling from Access or Access pulling from Excel?