Home > IT Answers > copying tables to excel
DatamanWarwick
5 pts.
 copying tables to excel
Microsoft Access 2010, Microsoft Excel 2010
How do I copy a table with more than 65000 records into an excel workbook?

Software/Hardware used:
ASKED: March 28, 2012  9:36 PM
UPDATED: March 29, 2012  4:23 AM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Older ver of MS excel has limit with 65536 rows per worksheet. Probably excel 2007 may help u !(though not sure) or some vba coding also helps. One more criteria is how did u copy / import rows from where i.e. access table / other databases…. See more info MS ref and excel 2007
If u have pre-excel 2007 wb open in excel 2007 in compatibility mode then, the wb has 65,536 rows, not 1,048,576. (just guessing, but not sure, cause u mentioned “table”).

Subhendu Sen
 22,035 pts.