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