Records From Excel To Access Through A VB Interface !!

Hello,

How can you extract records from an Excel(97) spreadsheet to be entered into an Access(97) Table by clicking on a command button on a VB(5) interface that acts as a 'go-between', between the two ?????

I would appreciate any help, code or links on this topic,

Thanks,
Andy.............

hi,

you can link an excel sheet to an access table so that when the excel sheet is updated it updates the access table.
Go to file - get external data - link tables. A wizard will guide you through the process - for more info see help in access and type 'linking spreadsheets'

Cheers

John