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