Records From Excel To Access Through A VB Interface !!

[VB_Novice]

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.............

[JohnBrockstar]

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