Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Apr 2003
    Location
    Morgantown, Pennsylvania, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error when outputting table to Excel through query (Outlook 2000)

    Hello,

    I am running Office 2000. I have a macro that runs a make table query, and then in the next line, outputs the recordset (the table) to Excel. The table created by this query can be anywhere from 15,000 records to 32,400 records. I am getting an error message that reads "There are too many rows to output based on the limitations specified by output format or by Microsoft Access."

    To my knowledge, I didn't put any limitations on the format, and Excel 2000 can hold up to 65,000 rows. In reading the help, it says that the Excel file is actually an Excel 98 file, but that should still be able to handle 65,000 rows.

    So why is Access not allowing me to move this table to Excel?

    Thanks in advance for any help provided.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error when outputting table to Excel through query (Outlook 2000)

    Francois

Posting Permissions

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