Results 1 to 6 of 6

Exporting a access file that is greater than 65,000 records

This is a discussion on Exporting a access file that is greater than 65,000 records within the Microsoft Access forums, part of the Question Forums category; Hi, I have a query I ran that has about 850,000 records. How can I export this to send it ...

  1. #1
    Board Regular
    Join Date
    Dec 2006
    Posts
    99

    Default Exporting a access file that is greater than 65,000 records

    Hi,

    I have a query I ran that has about 850,000 records.

    How can I export this to send it to someone?

    Can I create a .csv file in Access 2007?

    Please let me know.

    Thanks

  2. #2
    Board Regular
    Join Date
    Feb 2008
    Posts
    61

    Default Re: Exporting a access file that is greater than 65,000 records

    You can do it fairly easily via the EXPORT command. I don't have a copy of Access 2007 to hand so I can't tell you precisely, but on Access 2003, EXPORT is on the file menu. Select the export location and the file type (text) and click on Export All. You will then be presented with a wizard which will ask you a few questions including as what delimeter (eg Tab, Comma etc) you wish to use.

    HTH
    Martin

  3. #3
    Board Regular
    Join Date
    Jan 2009
    Posts
    867

    Default Re: Exporting a access file that is greater than 65,000 records

    read Sydney's post in this thread

    Extracting certain rows to excel

  4. #4
    MrExcel MVP
    Moderator
    SydneyGeek's Avatar
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    12,203

    Default Re: Exporting a access file that is greater than 65,000 records

    Quote Originally Posted by Lior123 View Post
    Hi,

    I have a query I ran that has about 850,000 records.

    How can I export this to send it to someone?

    Can I create a .csv file in Access 2007?

    Please let me know.

    Thanks
    You can create a CSV from Access. The TransferText method using the acExportDelimited option will give you a comma delimited file.
    Problem is opening it on the other end; Excel will spit the dummy over the number of rows. If they are opening in a database, no problem. If they want to use Excel, use the link James provided to break the query over multiple tabs.

    Denis
    Self-preservation: For when you've got yourself in a jam
    ------------------------------------------------------
    My site contains a number of Excel and Access Resources

  5. #5
    MrExcel MVP boblarson's Avatar
    Join Date
    Nov 2008
    Location
    Portland, Oregon, USA
    Posts
    1,961

    Default Re: Exporting a access file that is greater than 65,000 records

    Of course if you are using Excel 2007 then it will handle a million rows on a worksheet, right?
    Bob Larson
    Access MVP (2008-2010, 2011)
    Free Access Samples and Tutorials
    (includes Free Frontend Auto Update Enabling Tool).


  6. #6
    MrExcel MVP
    Moderator
    SydneyGeek's Avatar
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    12,203

    Default Re: Exporting a access file that is greater than 65,000 records

    If you use one of the new formats, and not .xls...
    Also assumes that the recipient has 2007.
    Good point though -- should have noticed that.

    Denis
    Self-preservation: For when you've got yourself in a jam
    ------------------------------------------------------
    My site contains a number of Excel and Access Resources

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com