98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel data to Access data
Excel data to Access data
Resolved · High Priority · Version 2007
Mon 20 Apr 2009, 14:26Trainer Simon said...
Excel data to Access data
How do I import/convert Access-data into Excel-data and vice versa?
Mon 20 Apr 2009, 15:54Trainer Amanda said...
RE: Excel data to Access data
Hello Simon
Thank you for your question.
Both programs have tools/facilities to be able to export data to the other.
In Excel, go to the Data tab, and have a look at the 'Get External Data' group of buttons. Click the From Access button. From here, you can browse to the Access database, and select the table or query results you wish to bring over into Excel. For further details, please see
http://office.microsoft.com/en-us/excel/HA100963001033.aspx
In Access, go to the External Data tab, and click the Excel button in the Export group. For further details please see http://office.microsoft.com/en-us/access/HA012241221033.aspx?pid=CH101759711033
Kind regards
Amanda
Mon 27 Apr 2009: Automatically marked as resolved.
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:Seeing named ranges as part of the zoomIf you have large areas of named ranges this works better. |
