Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

linking excel access

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking excel with access

Linking excel with access

ResolvedVersion 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.

Excel tip:

Large Icons on toolbar

You can make the buttons on your toolbars bigger by going to Tools / Customize / Options / select Large icons.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.