Question about Excel/Access Linked Table

[JumboCactuar]

Hi,
I'm fairly new to access and want to use it to store data which can be select queried from Excel.
But also would like to update the records directly from Excel (only 1 workbook)

So I seen you can create a linked table between a workbook and access, any data changed in the excel table is updated in access.

Though can I still add new records to the access table? Would it update in excel when refreshed?

 

[Trevor G]

Yes, I would suggest that connecting the table via the Data Tab in Excel and use the connections group.

 

[JumboCactuar]

Don't think linked table is the way for this.

As in excel you can't just load certain records from the DB (example today's date only)

You need to have the full table in Excel

ADODB update probably a better way so gonna have to figure it out.

Thanks