Exported Access report exceeds Excel line count

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The user has a routine Access report that the he wishes to export and save
each day as an Excel spreadsheet. Today, the report export line count
exceeds the allowable import line count for Excel. None of the three
workarounds described elsewere on this site will work.

To save today, the originating table was broken into three parts and the
report run against each piece. This is much too labor intensive and fraught
with opportunity for error.

Any suggestions?
 
You could write procedures in VBA code to determine length, create queries
to divide the information, run the reports, and save them to spreadsheet.
Once debugged, that would eliminate (at least some) opportunity for human
error in the process.

My question, however, would be "Is there not an alternative format for
saving the information that would serve the same purpose?" That is a great
deal of information for a human to scroll through and examine, and a
spreadsheet may not be the most efficient approach.

Perhaps, with some thought into what the user needs to accomplish,
additional forms and reports in the Access application would eliminate the
need for this (seemingly rather cumbersome) approach of saving a huge
spreadsheet each day.

Larry Linson
Microsoft Access MVP
 
Back
Top