Importing from MS teams / Hyperlinks

[pandorah]

Hi there, I have an MS Teams folder with multiple excel files in it. I want to import all the files each into their own individual table in Access. I've figured out how to import the whole folder. But it then creates a sort of table with a field that contains hyperlinks to all the files (one per row). So I either need a better way to import...or I need to know how to create code that opens each hyperlink and saves it as a table. This is my first time trying to get data from MS teams so I'm a little lost. Any ideas?

[pandorah]

Sorry, I should add that I'm working with Access 2013

[Bulzie]

Never done that from Teams but few questions. Is this a one time process and from then on you will be using Access or you going to be doing it again in the future? How many excel files you talking about? Can you download those to Excel and then you could link those directly to Access. But like I said I've never done with Teams so maybe there is a good way to do that other folks can speak on.

[pandorah]

Hi there, it would be a repeated action. 18 files. I was trying to avoid downloading 18 individual files; was hoping to get all at once somehow. I did find a solution though. I can download the whole folder as a zip file in one action...then copy / paste all into a main folder to then upload into Access via a form. A few more steps than I was hoping to do...but less then one at a time . Thanks for the response.