Excel Values Entered Then Values Populate In Access Table

  • Thread starter Thread starter apdc711
  • Start date Start date
A

apdc711

I currently have a spreadsheet that when I enter data in Excel, am I able to
create a Table where the info in Excel will populate in the Access Table? If
so, how do I go about doing that. I can do it in Excel, but I am trying to
avoid adding all these formulas and locking the cells.
 
You can link to the spreadsheet in Access. The data that you enter into the
spreadsheet can be viewed as a table in Access; however, you won't be able to
change the data within Access so that it will show up in Excel.
 
Jerry,
I think you meant ..'within Excel so that it will show up in Access' <g>

Jeanette Cunningham
 
Back
Top