Results 1 to 2 of 2
  1. #1
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    419

    Disable showing acImport

    Hi, when I import excel sheet into access programmingly I always get a bar on the bottom right of access that shows the import. How can I disable this showing when importing. Then turn it back on after import.



    Code I use is,

    DoCmd.TransferSpreadsheet acImport, , “Table”, file, True, “sheet!”.

    Thanks

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    You DONT want to see the progress?
    !!??

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

Similar Threads

  1. Replies: 4
    Last Post: 06-27-2018, 01:11 PM
  2. Replies: 12
    Last Post: 05-31-2016, 02:12 PM
  3. Replies: 8
    Last Post: 07-02-2014, 10:58 AM
  4. Import Excel data with acImport
    By djleggins in forum Import/Export Data
    Replies: 2
    Last Post: 11-19-2011, 11:09 AM
  5. DoCmd.TransferDatabase acImport Issue
    By remingtont in forum Programming
    Replies: 0
    Last Post: 11-12-2010, 03:59 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