Access: Upload Data From Excel

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,732
Office Version
2016
Platform
Windows
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
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Watch MrExcel Video

Forum statistics

Threads
1,102,541
Messages
5,487,462
Members
407,601
Latest member
soccer4ward

This Week's Hot Topics

Top