Results 1 to 2 of 2
  1. #1
    RAMSES955i is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2012
    Posts
    1

    Exporting to Excel

    Dear all,

    I am looking for a solution for the following task:
    I have a MOVEX ERP-System and I am querying data from various tables via ACCESS, e.g. financial bookings, spent hours, manufactured material, ... all combined under 1 project number. I now import my perfectly running queries into Excel, as most of our users are not familiar with Access, but Excel. So I've created a VB script accessing my queries and importing all data into pivot-tables. So far so good, everybody is happy.

    But: In Access you can 'ask' for certain inputs like the project number, if you put the Criteria into cornered brackets, like this: [PROJECT]. Running the query now it would ask for the project number an retunr the matching results. It is working fine in Access, but I don't know how to use this function from Excel-side. Not knowing this I end up providing an Access-file for each project number, where the projetnumber is my fix criteria instead of having 1 central Access-query with a variable 'projectnumber' criteria for all my different projects.

    Does anyone know how to solve this?

    Thank you very much in advance and have a nice day.

    Best regards from sunny Sweden,
    Ramon

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    The Excel find/replace dialog is not adequate? Maybe this will give you some ideas or convince you this is entirely bad approach http://www.cpearson.com/excel/FindAll.aspx

    Real solution is to educate users in Access and/or build friendlier user interface in Access.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 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. Exporting to Excel
    By Andrias14 in forum Access
    Replies: 3
    Last Post: 03-20-2012, 06:04 AM
  2. exporting to Excel
    By johnririe in forum Import/Export Data
    Replies: 6
    Last Post: 08-23-2011, 10:16 AM
  3. Exporting to Excel
    By TheDeceived in forum Programming
    Replies: 0
    Last Post: 11-15-2010, 08:56 AM
  4. Exporting to Excel
    By DreamOn in forum Import/Export Data
    Replies: 1
    Last Post: 05-23-2010, 10:27 PM
  5. Really Need Help With Exporting to Excel
    By graviz in forum Import/Export Data
    Replies: 0
    Last Post: 09-24-2009, 08:29 AM

Tags for this Thread

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