View Single Post
Old 06-14-2018, 04:31 AM   #6
MajP
Newly Registered User
 
Join Date: May 2018
Posts: 604
Thanks: 8
Thanked 138 Times in 136 Posts
MajP will become famous soon enough
Re: Easiest way to get Excel table into Access

Quote:
The reason I ask is because it is not I who is doing the import, but end users. So, they won't have access to the import wizard... or will they? No, I think they would have to know exactly which table the data was being imported into.
There are many options, but you will have to provide some details on your business process. How is the database deployed? How are the spreadsheets used? Type and frequency of import, etc. Maybe you can simply train the users how to use the native import capability, or you might have to automate some processes for them.
MajP is online now   Reply With Quote
The Following User Says Thank You to MajP For This Useful Post:
CNorway (06-14-2018)