Easiest way to get Excel table into Access
I have for the past several years just used a datasheet to pull in data from Excel into Access. However, I was wondering if there is a better way to do it?
The advantages I have seen is that if the columns are dirty in Excel, the user will get an error. Also, the end user can see immediately that the paste went correctly.
Though, maybe there is a better way of getting an Excel file into a table? Any help would be greatly appreciated.