Exporting data from MS Access to MS Excel

J

jbkirby

Is there a work around to the problem wherein I have to export records
greater than 16000++( I think this is the limit for the export)?

Does this problem exists in higher versions of MS Access?
 
M

Maurice

Must be the restriction from Excel 97. You could try splitting your data and
try to place it in multiple sheets in the excel workbook.
 
K

Klatuu

It sounds like you are on an older version of Access or Excel. For later
version, the limit is 64,000. In 2007, I think it is like a million. You
will either need to split the data into separate worksheets or upgrade you
Excel and Access.
 
J

jbkirby via AccessMonster.com

How do you employ this one?
Must be the restriction from Excel 97. You could try splitting your data and
try to place it in multiple sheets in the excel workbook.
Click to expand...
 
Top