We have 50+ spreadsheet to import to access monthly. Instead of using Get External Data > Import 50+ times, is there a better way to automate the process ? Also, I discover that if you don't name the data range in Excel, you tend to get a lot of blank records imported. Anyway of solving these problems ?
Thank you
Thank you