Connecting Fields in Access and Excel

[bigmacholmes]

HI all,

I have an access database that has fields that i want to be entered externally via excel. I want to be able to manipulate the data from access and excel. If you change in one, it will reflect the change in the other.

I want this to happen seemlessly, with a notification to either end when either end is changed.

Linking to an excel sheet from access doesn't seem to work because you can not change anything in the fields that were entered in excel from access.

I have also tried creating a connection from excel to access. I can change the data in access and it reflects in excel, but if i change the field data in excel, it doesn't reflect in access.

Thanks in advance..

[June7]

As far as I know the read-only aspect of Excel/Access links is by design. Would have to use VBA to make the edits into the linked file.

[bigmacholmes]

How would I accomplish this with VBA?

[June7]

With elaborate code. There is a lot of examples out there. Try a Google search on topic: VBA Access edit Excel