Access: Upload Data From Excel

[gheyman]

I know you can have a Template and upload/import the data into Access.

My question is, can you do that from the Excel Sheet or do you have to import it from Access (have access Open and tell it to import from there vs Button on the Excel Form that automatically uploads it)

Thanks

 

[welshgasman]

http://lmgtfy.com/?q=excel+export+to+access+database

If used, this is one of the links
https://www.onlinepclearning.com/export-from-excel-to-access/