Exporting Access query to Excel

[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!

 

[Marty Snider]

-----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!

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