How do I live link data from Access to Excel? | Excel forum

Hi Kim, Thank you for the post, In answer to your question;
You have the option in Access to link to an external table or to an Excel spreadsheet.
If linking to an Excel sheet the sheet must be created and data inserted as a database or as a list, this requires the rules of database to be adhered to; ie. no gap between field headings and data the data should be consistent with the heading, where a row gap or column gap appears the table will be considered to have ended etc.
Using the Menu command in Access; File, Get External Data, Change your file type to Excel Spreadsheet, choose link and navigate to your chosen file; follow the wizard options to select your choices.
If however you wish to bring a table, from Access to xcel you should consider using the Menu command Data, Get External Data and choose the New Database Query option, follow the steps to choose an Access Database and then navigate to the database you wish to utilise, choose the table and confirm the fields then you can import the data.
I hope that helps, best regards Pete.