Exporting Access query to Excel

  • Thread starter Thread starter Marty Snider
  • Start date Start date
M

Marty Snider

When I try to export an Access 2002 query to Excel 2002 I
get the message "There are too many rows to output, based
on the limitation specified by the output format or by
Microsoft Access." The query I want to export only
contains 8 columns and less than 30,000 rows. Can I
increase the limitation? If so, where/how?

Thanks!
 
-----Original Message-----
When I try to export an Access 2002 query to Excel 2002 I
get the message "There are too many rows to output, based
on the limitation specified by the output format or by
Microsoft Access." The query I want to export only
contains 8 columns and less than 30,000 rows. Can I
increase the limitation? If so, where/how?

Thanks!
Click to expand...

Never mind! I found the solution in the Knowledge Base.
(Duh!) It works to use Excel to import the data from
Access.
 
Back
Top