98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » How do I live link data from Access to Excel? | Excel forum
How do I live link data from Access to Excel? | Excel forum
Resolved · Low Priority · Version Standard
Kim has attended:
Excel Intermediate course
Excel Advanced course
How do I live link data from Access to Excel?
how do you link access and excel?
RE: How do I live link data from Access to Excel?
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.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Selecting your working rangeIn excel if you have an area you want to highlight, press Ctrl + * or Ctrl+Shift+8 (to get the *). This will select your working range. |