Update Access Table from Excel using DAO

[vish2025]

Hi All,

If any one can help me out. I am new in VB Macro and trying to write the macro for update access table from Excel. Using below codes but getting error on ".Find".
Macro Reference seeting - Microsoft DAO 3.6 Object Libraey

If you r having any other code for the same tack pls guide and suggest....
Thanks in advance.....
Code:-

Please Login or Register  to view this content.

[romperstomper]

What error are you actually getting?

[vish2025]

What error are you actually getting?

The Error is :-

Compile Error:
Method or data member not found

[vish2025]

The Error is :-

Compile Error:
Method or data member not found

I am not sure about the code also. R these code able to update the existing records in access from excel.

[romperstomper]

DAO recordsets do not have a Find method - they have FindFirst, FindNext etc. - so you need to use one of those instead.

[vish2025]

Use the same but getting the error can someone help with other codes which update access table from excel.

[romperstomper]

What code did you use and what error did you get? We aren't psychic.