Recent content by chrismann85

Thanks I have created the linked tables in Access. How do I go about writing a macro in Excel to update the tables in Access? So far I have been getting by recording them.

Hi, I have an Excel Workbook that extracts tables from an Access Database using a command button. These tables are then modified (new fields and records added) in Excel. Is there a way to feed this back into access with a command button from excel? So that when I click the button, the data from...