how much access database information can be accessed from excel in real time? or at least updated when the workbook is opened and can i add or change database records directly from excel?
You can use Data>Get External Data>New Database Query...
to link to an Access table or Query. this can be set to update whenever the spreadsheet is opened and it can be refreshed on demand.
I don't think that data linked from Access will be updatable from Excel but excel data can be linked to Acces and this will update.
Access and Excell work together for automation so you could use code to update records between them.
Using code in an Excel VBA module, you can do practically everything. There's a couple features like compressing the database that may pose difficulties depending on which version of access you are using...but, from VBA, you can get to any object within Access.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
