How do I link Excel to Access?

[Tech.Zoan]

I got some help asking this in the Access group but I can make it work
quite the way i need it to so here it goes...

I have an Access database that contains job #'s and the associated
project name among other fields. Now I want to create an employee
timesheet that contains several lines where i can just punch in the
job # and the job name will automatically be fetched from the Access
database and displayed on my timesheet right next to the job # i just
typed in. Because the guys can work on several job sites on any given
day... my timesheet will have several lines to enter different job
#'s.. therefore each line must accept a new job # and retrieve the
associated project name.

I was able to make the link and retrieve the appropriate record but it
retrieves both the job# and project name but I do not need to have the
job# appear as I already punched it in. Also, it would not allow me
to indicate in which cell to input the field value and it also would
show the name of the fields which i don't need to appear. So the
problem seems to lie with the "Return Data to Microsoft Excel" part of
it.

I'd appreciate if someone could show me how to do this. Thanks!

 

[Leslie Isaacs]

Why do you want to use both excel and access?
I'm no expert but I would have thought you could do what you want much more
easily just within access.
You can view data in access with a form in 'datasheet' view, which looks
just like an excel worksheet, if that's important for your timesheets.

Les

 

[Tech.Zoan]

The reason why I use both is because originally, this company was only
using Access to keep track of jobs and to create job #'s. When I
arrived, the timesheets were still being done manually and so I
decided to use Excel so it would be easier to calculate labour cost
for each project.

Currently, the employees enter the job # on their timesheet and the
amount of hours they worked on that job and they do so for every
workday.

I have to look in Access to find out what job name that job # refers
to. I want to automate that by entering the job # in a cell on their
timesheet and have the job name fetched from the Access database and
popped up in specified cell.

I have had limited success in accomplishing this. It retrieves the
correct record but it displays both the job # and the job name where I
don't need to have the job # repeated since I already inputted once.
Furthermore, it won't let me specify exactly what cell I want the job
name to appear in.

 

[Nick Hodge]

Perhaps this will help?

http://www.nickhodge.co.uk/gui/datamenu/dataexamples/externaldataexamples.htm

Near the bottom (Using parameters in External ODBC Data Queries)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html