Results 1 to 2 of 2
  1. #1
    Join Date
    May 2014

    Unanswered: Populating excel sheet through Access query

    What I am trying to do is populate the specific fields on excel sheet based on access query. so say I have 3 separate fields Name, Job, Salary on excel sheet (already designed excel sheet). and my access query has all 3 fields pulled up for all employees. Now if a person selects his "Name" on access form person should be able to see prepopulated excel sheet with his name, job and salary. I know I have to go recordset path. But I have never done this before. Please guide with step by step what should I do and make it possible.

  2. #2
    Join Date
    Dec 2003
    Dallas, TX
    Good evening,
    In Excel 2003 go to: Data tab and go down to click Import External Data. Click Import Data. In the SelectDataSource window at the bottom it has FilesOfDataType... Click on Access Databases or whatever you have. Then do to the Look In window to navigate to where you have your Access tables stored and go from there. Should be pretty simple.

    Have a Great Day,

Posting Permissions

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