CONNECTING EXCEL WITH ACCESS DATABASE

Closed
RAMU - Jun 8, 2010 at 08:48 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Jun 8, 2010 at 04:50 PM
Hello,
is it possible to connect excel with ACCESS database,so that changes made in excel or access should get updated on the other......please help for this task......


1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jun 8, 2010 at 04:50 PM
Only if you are using VB. From excel you have to connect to DB
and from access, you have to open the excel file via code and update it
1