Results 1 to 4 of 4
  1. #1
    MarkABarb is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2016
    Location
    Wichita, KS
    Posts
    2

    Export to excel and copy to clip board taking a long time with Oracle Backend


    We recently migrated an Access frontend with a SQLServer backend to an Oracle Backend. We are using the Oracle Instant Client 12.1 drivers. Queries fetch data into DataSheets in a reasonable amount of time. However, when the users highlight rows in a datasheet and Cntl-C, it takes an extremely long time to copy the data if there are more than 500 rows. If the user tries to use the Export To Excel spreadsheet built in command, there are similar issues. Is there any tuning I can do to cut down this time?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    try exporting to excel
    docmd.transferspreadsheet....

    then open it in excel
    call shell(.....

    there should be no delay.

  3. #3
    MarkABarb is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2016
    Location
    Wichita, KS
    Posts
    2
    Thank you. That gives me a path forward. Any idea why copy to clipboard and the built in Export To Excel commands take so long? That solution would not change the users' processes.

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    dunno, but Ive seen it do it.

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

Similar Threads

  1. Replies: 1
    Last Post: 09-03-2015, 09:25 AM
  2. Query taking too long, suggestions?
    By theperson in forum Queries
    Replies: 11
    Last Post: 05-29-2013, 10:17 AM
  3. Replies: 19
    Last Post: 11-01-2012, 08:03 AM
  4. Replies: 3
    Last Post: 10-13-2011, 02:27 PM
  5. ole chart copy to clip
    By jtkjames in forum Programming
    Replies: 4
    Last Post: 07-28-2010, 11:05 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