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 » Linking excel with access
Linking excel with access
Resolved · High Priority · Version 2003
Linda has attended:
Access Introduction course
Excel Introduction course
Linking excel with access
how do i link data like contact from excel to acces database
RE: linking excel with access
Hi Linda, thanks for the query. There are various ways to bring in contact data from Excel to Access, the easiest is to simply open an Excel file in Access. This will trigger a wizard to format the incoming data appropriately and set up tables etc. There is some loss of functionality (particularly with regard to formulae) but the data itself will be imported intact. Otherwise, click on File - Get External Data and navigate to your data source.
Hope this helps,
Anthony
Thu 18 Jun 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:##### displaying in ExcelWhen you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake. |