CONNECTING EXCEL WITH ACCESS DATABASE

Closed
RAMU - Jun 8, 2010 at 08:48 AM
rizvisa1 Posts 4478 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......


Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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