View Single Post
Old 06-14-2018, 02:04 AM   #1
CNorway
Newly Registered User
 
Join Date: Feb 2018
Posts: 26
Thanks: 22
Thanked 0 Times in 0 Posts
CNorway is on a distinguished road
Easiest way to get Excel table into Access

Hi,

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.

Thanks,
Chris

CNorway is offline   Reply With Quote