I already have a running connection between MS Excell and a MODICON TSX PLC. But I have not succeeded to find the right VBA keywords which should be used in MS Access.
I believe I have to use the CreateObject command to initialise the connection, but I don't know the parameter. As well I need the commands to add the items and reading and writing values in the PLC.

 

I have the same problem than you. I don't know how to connect a PLC with MS Access Database, I would like that you write me when you get it.