Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / November 2007

Tip: Looking for answers? Try searching our database.

How do I link Excel to Access?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tech.Zoan - 30 Oct 2007 21:06 GMT
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 - 31 Oct 2007 18:34 GMT
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

>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...
[quoted text clipped - 18 lines]
>
> I'd appreciate if someone could show me how to do this.  Thanks!
Tech.Zoan - 13 Nov 2007 13:28 GMT
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.

On Oct 31, 12:34 pm, "Leslie Isaacs" <leslie.isa...@gp-n85011.nhs.uk>
wrote:
> 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
[quoted text clipped - 3 lines]
>
> Les
Nick Hodge - 13 Nov 2007 16:23 GMT
Perhaps this will help?

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

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

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
web: www.nickhodge.co.uk

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

> 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
[quoted text clipped - 27 lines]
>>
>> Les

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.