Connection bt excel and access

[asif pasha]

Hi,
My boss gave me a project to do, the project is creating forms in VB with the help of excel, however i have done, but i want to create a connection between the feilds in form with the access fields.
For example : the table in the access contains System no, ID, and DOB. which should be linked to the form system no, id and dob respectively. When i enter the new data in the form it should be updated in the access table. Please help me out with this.

Unfortunately i dont have the VB install in the system.

 

[Kryst51]

Just a quick question, where does excel enter into the picture?

 

[asif pasha]

I understand, this is a access forum, but there is something access related. Infact back end of excel (press shift F11) there is VB for simple programing and forms.