Close

Results 1 to 3 of 3
  1. #1
    DF PiMP ek247's Avatar
    Join Date
    Dec 2002
    Location
    Birmingham
    Posts
    358
    Thanks
    22
    Thanked:        4
    Karma Level
    243

    Default Linking Access to Excel

    Can anyone help me out. PLEASE
    at college a few years back i made a Access database which linked to M$ xcel. It had records of employees length of service, salary age, job type and so on.

    the problem is at work the employer wants me to make similar database, problem is i lost all my past notes and am completely stuck. :|

    can anyone help me out.

  2. #2
    DF PlaYa Jesta's Avatar
    Join Date
    Apr 2002
    Location
    London
    Posts
    935
    Thanks
    0
    Thanked:        0
    Karma Level
    278

    Default Re: Linking Access to Excel

    ok...
    u had access linked with excel u say?

    u can make a simple database in access quite easily

    1st..

    Think of all the info u want to store.
    then think of how that info will be stored (datatype)
    when u get that, let us know..

    It had records of :
    employees
    So ..
    Employee name : (String)
    Employee Address : (String)
    length of service : (if your gonna do calculations make it an integer) else a char.
    salary : (again if u gonna use a fuction to sum it up use integer )
    age : as above (common to use string)
    job type : String..
    and so on.

    when uve done that, open up Access and create a table...
    then we'll go from there.

    good luck, if u need a hand gimme a shout

  3. #3
    DF PiMP ek247's Avatar
    Join Date
    Dec 2002
    Location
    Birmingham
    Posts
    358
    Thanks
    22
    Thanked:        4
    Karma Level
    243

    Default Re: Linking Access to Excel

    cheers m8, help REALLY REALLY appreciated....will get back to you

Similar Threads

  1. Excel/Access Experts
    By PrideandPassion in forum PC Problems
    Replies: 1
    Last Post: 19th January 2009, 08:31 PM
  2. Excel to Access!
    By ParkerDigital in forum PC Software
    Replies: 2
    Last Post: 23rd June 2006, 08:56 AM
  3. Access To Excel Import & Calculate
    By MonkeyBalls in forum PC Software
    Replies: 0
    Last Post: 22nd June 2006, 02:05 PM
  4. Linking VB.NET to Access
    By candigirl90 in forum Programming
    Replies: 2
    Last Post: 17th April 2004, 09:24 PM

Social Networking Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •