Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2021

    Export from Access to Excel

    How can i export from access to excel all or filtred records?
    I have a "Table = Database" with a "Query = [Query Pratiche Studio Totale 2]". From this Query i have a "Form = ComboBoxCustomer" which is a subform in "Form = ComboBoxSearch" where i have different boxes to search different words like name, lawer, etc.
    Now i want export to excel filtred records in subform ComboBoxCustomer with a button (maybe VBA?). I would like create a table where i have just some specific columns.
    Is it possible?
    Actually if i try to export to excel i have the boxes' ComboBoxSearch but not records' columns.
    Attached Thumbnails Attached Thumbnails comboboxcustomer.PNG   comboboxsearch.PNG   Excel export.png  

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    Could export a simple report.

    If you want to allow different fields to be included in export, that will probably require VBA using DAO and QueryDefs to modify query object then export query.
    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 12-11-2017, 01:36 PM
  2. Replies: 3
    Last Post: 04-07-2016, 04:36 AM
  3. Replies: 7
    Last Post: 04-25-2013, 03:47 PM
  4. Export from Access to Excel
    By Eowyne in forum Import/Export Data
    Replies: 5
    Last Post: 04-23-2011, 07:08 PM
  5. Access export to Excel
    By Rick West in forum Import/Export Data
    Replies: 4
    Last Post: 01-09-2010, 03:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums