Exporting data from MS Access to MS Excel

  • Thread starter Thread starter jbkirby
  • Start date Start date
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?
 
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.
 
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.
 
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...
 
Back
Top