Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Fill Excel Listbox from Access (XP; SP3)

    Is it possible to populate an Excel listbox from an Access query result?

    Thanks,
    John

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Fill Excel Listbox from Access (XP; SP3)

    You can use Data | Get External Data | New Database Query... to import the query result into an Excel worksheet> Excel will automatically assign a name to the imported range. You can set the list fill range of the list box to this name.

    If you don't want to import the data, you'd have to use code: open a (DAO or ADO) recordset on the query, loop through the records and populate the list box.

Posting Permissions

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