linking excel access

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

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

Linking excel with access

resolvedResolved · 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.


 

Excel tip:

##### displaying in Excel

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

This is a common misconception - what this actually means is that the cell is not wide enough to fully display the content of the cell.

All you need to do to see what is actually in the cell is to widen the column that the cell is in.

View all Excel hints and tips


Server loaded in 0.08 secs.