+ Reply to Thread
Results 1 to 1 of 1

Excel Template vlookup in Access Table

  1. #1
    Registered User
    Join Date
    03-21-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    90

    Excel Template vlookup in Access Table

    Hi,

    I was wondering what is the best way to retrieve data from Access to an Excel sheet.

    I have an excel template that I extract the tables from Access and have the VBA code just filling in the cells by doing vlookups from this Access extract.

    I was wondering how could code the Excel template to retrieve the data straight from the database tables.


    For instances, cell A1 needs to be populate with the costs of widget1, so Lolokup Access tblWidgets and pulls back the cost related to widget1. Then cell A2 needs to be populate with the description of widget1, so Lolokup Access tblWidgets and pulls back the description related to widget1. etc



    Thanks!
    Last edited by jadown; 04-04-2014 at 02:09 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Importing data from Access to Excel, but I need to vary the table from Access
    By Liz L. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2006, 09:15 PM
  2. Localize Access Report and Excel Template
    By Peter in forum Excel General
    Replies: 0
    Last Post: 03-29-2006, 03:20 AM
  3. vlookup and Access Database Table
    By finster26 in forum Excel General
    Replies: 1
    Last Post: 01-06-2006, 06:20 PM
  4. Pull info from access to template in excel?????
    By jwr in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-26-2005, 11:05 PM
  5. Excel template and access questions
    By galgolfer63 in forum Excel General
    Replies: 1
    Last Post: 06-21-2005, 03:05 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1