Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 20th 05, 03:01 AM
booris
 
Posts: n/a
Default Trying to link MS Access to MS Excel

Hi all,
I have a list of clients information stored in MS access. When i use
MS Excel and as i type in the name of my client, my clients other information
like address, tel no, fax no and all will appear. How do i go about doing it.

I have installed Microsoft Accesslinks Add-in but does not help.

PLssssssss help...............

THNKS

  #2   Report Post  
Old January 20th 05, 06:12 PM
Bill Manville
 
Posts: n/a
Default

Booris wrote:
I have a list of clients information stored in MS access. When i use
MS Excel and as i type in the name of my client, my clients other information
like address, tel no, fax no and all will appear. How do i go about doing it.


I would create a QueryTable in Excel (details depend on your version of Excel -
always worth telling us), e.g. Data / Get External Data / New Database Query.

If you have a relatively small number of clients then you could just query the
whole table into Excel and use VLOOKUP functions to extract the fields relevant
to the client you type in.

If you have a large number of clients then you could use a Parameter query -
where the specific client's information is retrieved when you type the name into
a specific cell.

I suggest you explore those areas and come back with a more specific question if
you get stuck.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to link two charts in excel anjolaoluwa Charts and Charting in Excel 1 January 24th 05 08:34 PM
Creating GIFs in Excel 2003 for use in Dreamweaver Lou Crandall Charts and Charting in Excel 2 January 2nd 05 07:58 PM
Charting Data from Excel DavidM Charts and Charting in Excel 4 December 30th 04 02:31 PM
populating data from excel into access Chris Links and Linking in Excel 1 December 15th 04 07:50 AM
How do link to a remote worksheet using the path value in a field? Michael T. Links and Linking in Excel 3 December 11th 04 08:45 AM


All times are GMT +1. The time now is 01:49 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017