I’m very new to using VBA in Access, so if anyone can help me I would greatly appreciate it.
This is what I need help with:
I have to create a system that automatically imports Excel files from a folder in the hard drive into an Access table. I want to make it so all the users have to do is hit a button and everything happens automatically. I know it’s possible because I was able to create it using VBA in Excel but I can’t make it work for Access.
I believe I have to use "currentproject.path" instead of "ThisWorkbook.Path" but I’m not entirely sure. All the files are save in this format: “Seating Chart Report- city name.xls” The city name is different for every file. The subfolder all the files are saved in is called “Attachments” and the table they need to be imported into is called “Seating Chart.” The Excel files and Access database are both located in the same main folder called "Seating Chart Project."