Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Trying to make an excel template that saves data in access. 1
- Thread starter bcblair
- Start date
-
1
- #2
Excel doesn't save data in Access, at least not without macros. Here's how you do it the easy way:<br>
<br>
LINK the table (Excel file) to Access by doing a File-Get External Data-Link Table.<br>
<br>
Then, when you update your Excel file, it will automatically be updated in your Access database. YOU CANNOT EDIT A LINKED TABLE IN ACCESS, you must edit it in (this case) Excel.
<br>
LINK the table (Excel file) to Access by doing a File-Get External Data-Link Table.<br>
<br>
Then, when you update your Excel file, it will automatically be updated in your Access database. YOU CANNOT EDIT A LINKED TABLE IN ACCESS, you must edit it in (this case) Excel.
- Status
Similar threads
- Locked
- Question