Close

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

    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 VIP Member Jesta's Avatar
    Join Date
    Apr 2002
    Location
    London
    Posts
    935
    Thanks
    0
    Thanked:        0
    Karma Level
    290

    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 VIP Member ek247's Avatar
    Join Date
    Dec 2002
    Location
    Birmingham
    Posts
    358
    Thanks
    22
    Thanked:        4
    Karma Level
    255

    Default Re: Linking Access to Excel

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

Similar Threads

  1. excel for fee
    By bobbobb in forum Programming
    Replies: 8
    Last Post: 7th March 2005, 11:22 PM
  2. need access but don`t know password
    By yorg in forum PC Problems
    Replies: 4
    Last Post: 11th October 2002, 06:59 PM
  3. Excel graph problem
    By marktb in forum PC Problems
    Replies: 2
    Last Post: 9th October 2002, 04:42 PM
  4. access problem
    By Aware in forum Forum Bug & Error Reports
    Replies: 1
    Last Post: 30th September 2002, 09:24 PM
  5. Free to access channels
    By benjiguy in forum Digital Satellite TV
    Replies: 4
    Last Post: 23rd September 2002, 09:56 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
  •