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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access #Error & Excel Pivot 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Populating Fields Automatically 2
Two separate tables in Access I need to match the data using a Pke 2
Trying to run excel vba code when cell value changes from empty to entered value. 1
Excel Custom trendlines and R^2 values 0
Importing data from excel spreadsheet 1

Back
Top