Results 1 to 3 of 3
  1. #1
    shabar is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2013
    Posts
    66

    How Can export Large table part by part


    I've got table with large number of rows which cannot export to excel at one go. (I tried to export with out format option
    Even that didn't work.)


    So how would I do that part by part. Or is there other effiecient way of doing same






    Cheers




    Shabar

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    Try exporting query that filters the records into smaller datasets.
    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.

  3. #3
    shabar is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2013
    Posts
    66
    Thax June7

    No other way.......... I guess

    Cheers

    Shabar

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

Similar Threads

  1. Replies: 1
    Last Post: 09-07-2012, 10:45 AM
  2. Format part of field
    By tylerg11 in forum Forms
    Replies: 2
    Last Post: 01-21-2012, 01:48 PM
  3. Adding Part Number on demand that is not in table
    By patrickwelch in forum Programming
    Replies: 4
    Last Post: 03-21-2011, 07:53 PM
  4. WHERE as part of JOIN not after
    By thestappa in forum Queries
    Replies: 1
    Last Post: 05-14-2010, 10:52 AM
  5. Replies: 1
    Last Post: 02-01-2010, 06:12 AM

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