Excel link to Access Table

[ry94080]

Hello,

I have an excel workbook that is linked to an Access table. I am able to view the table just fine through "Connections".

However, i was wondering if it were possible to update the values in Excel so that it would update the values in the Access table? When i try it, it doesn't actually update. When i refresh the connection, it just refreshes the original data from the access table.

Any ideas?

[June7]

AFAIK, that connection is one-way - edits to data displayed on sheet will not pass back to Access. Would have to use VBA to make a connection to Access and edit data.

Why are you wanting to use Excel as interface to Access?

[ry94080]

AFAIK, that connection is one-way - edits to data displayed on sheet will not pass back to Access. Would have to use VBA to make a connection to Access and edit data.

Why are you wanting to use Excel as interface to Access?

After much research, that is what i'm also discovering. Our users are just much more familiar with Excel and i was trying to avoid building a form for the data entry/edit.

Looks like i'll have to go and do that. Thanks for the confirmation!

[Bob Phillips]

You don't have to do that. I run my home accounts from Excel, with an Access database to hold all of the transactions.

Excel gives you plenty of tools, Power Query, PowerPivot, pivot tables, SQL/ODBC. And then you can use the Excel to input the data you want to update to Excel.