How to export Excel to Access

[vladk]

Hi,

I would like to put a button at my spreadsheet to load it's data into the corresponding Access table.

I learned how to do it from the Excel\Data menu. I would prefer to automate this procedure also. I need to add new Excel rows to the existing records in Access. The macro recording does not help in this case. I guess I would need to use Access.Application object somehow.

I will appreciate any help.

Thank you

Vlad