Adding data to an Access database table using InputBox VBA

[stupurd]

Hello all,

I'm trying to find out how to add a record to an Access table called 'work_list' with the database 'data.accdb' using VBA from Excel that displays Input Boxes to collect the required information.

Once I have this working I will eventually change it to a userform to collect the data.

Everything I've found on the internet so far doesn't seem to work. I'd like all the data transfer to happen without having to open Access.

Thanks in advance,

Stuart