yes.
That's the simple answer.
My question is why? If you're entering data in Access, why use Excel as a front page?
Here's a page that shows how to export data from excel to access:
Export data from Excel to Access (DAO) using VBA in Microsoft Excel[
^]
Unfortunately, for me, part of the code is hidden behind an ad. But, if you highlight the code, you should be able to copy and paste it to see it all.
Submit an article or tip