Results 1 to 5 of 5

Thread: "Autofilling" Excel sheet from an Access DB

  1. #1
    Variable Bitrate
    Join Date
    Jun 2002
    Location
    Indiana
    Posts
    310

    "Autofilling" Excel sheet from an Access DB

    Ok... this is something for my job and need a lil help. So thought i would bring it to the programmers.

    I am making excel sheet where
    column 1 = customer id
    column 2 = customer name
    column 3 = address
    column 4 = telephone

    I have an access database that contains all my customer information.
    What i want is if i lets say i enter 222343 into column one and it is a valid cusotmer in my access db then it would fill out the customer name, address and telephone columns in my excel sheet to save time.

    I assume this would need some type of VB code, but i am not not very knowledgable with VB. So i am gonna play dumb.

    Only code i do at work is Clarion and sometimes cognos

    If anyone could help me out or even show me a sample of what i am trying to acheive so i could analyze it then i am sure it wouild make sense.

    thanks!

  2. #2
    Maximum Bitrate
    Join Date
    Oct 2003
    Posts
    664
    What does this have to do with carputers?

  3. #3
    Map Monkey Creator Ninja Monkey's Avatar
    Join Date
    Aug 2003
    Location
    Warrington, UK
    Posts
    1,012
    You don't need any VB code to do this, excel can get data from a database and do what you want very easily.

    BUT...what on earth are you asking here for?? Take it here
    Destinator 3 For PC! - http://www.map-monkey.co.uk/

  4. #4
    FLAC IntellaWorks's Avatar
    Join Date
    Jun 2004
    Location
    NH
    Posts
    1,173

    .

    You can easily import a database into excel...
    Progress [I will seriously never be done!]
    Via EPIA MII
    512MB RAM
    OEM GPS (embedded)
    nLite WinXP pro on
    1GB Extreme III CF card
    Carnetix 1260 startup/ DC-DC regulator
    Software: Still, re-Writing my existing front end in .Net

  5. #5
    Low Bitrate
    Join Date
    Oct 2004
    Location
    UK
    Posts
    82
    use ADO to query the database, and fill out the rest of the columns

Similar Threads

  1. mp3car.com access problem???
    By GRUNT in forum Off Topic
    Replies: 1
    Last Post: 07-05-2004, 09:32 PM
  2. wireless card or wireless car and access point?
    By vanroth in forum Wireless Communications
    Replies: 7
    Last Post: 06-08-2004, 10:46 AM
  3. AT&T Cellular Internet Access / Bluetooth
    By ukchris in forum Wireless Communications
    Replies: 10
    Last Post: 05-27-2004, 09:09 PM
  4. help with access to shared hard drive delay
    By cproaudio in forum General MP3Car Discussion
    Replies: 7
    Last Post: 09-26-2002, 01:40 AM
  5. Which email service for POP3 access?
    By Duphus in forum Off Topic
    Replies: 12
    Last Post: 05-31-2002, 12:20 AM

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
  •